Timecard - Formula to Calculate [SOLVED]

[alsampels]

Hi all~

I am creating a timecard. It is for one employee that works at three different sites over the span of one month. Each day that is worked the time is entered as hh:mm in the appropriate site column. I need a formula that will total the hours and minutes based on a 60-minute hour in each column. Is this possible and if so, can anyone offer some assistance? I would greatly appreciate it!


Thanks!

Amy

 

[Hui]

Amy


simply use

=Sum(B2:B20)


or whatever range your column is in


Then set the Custom Number format for the sum cell to

[h]:mm


Select the cell

Ctrl 1

Number Tab

Custom

Enter [h]:mm in the type dialog

 

[alsampels]

Amazing! Thank you so much Hui!!! It works perfectly and was so much easier than I was trying to make it. Thanks again for your help!