Calculating Time?

[Trish]

I have a spread sheet that in colum a I enter the time in, B is Time out, C
is total time for that period, C is total for the day. Now I am trying to add
all the total for the day, which it does fine unless the total time for the
week is greater then 24hours. Ex:
Daily Total: 0:00 Daily Total: 0:30 Daily Total: 1:00
Daily Total: 0:00 Daily Total: 2:00 Daily Total: 1:00
Daily Total: 0:00 Total: 4:30 Correct

Daily Total: 4:00 Daily Total: 4:00 Daily Total: 5:00 Daily Total:
4:00 Daily Total: 4:00 Daily Total: 4:00 Daily Total: 4:00 Total: 5:00 Not
Correct

 

[Roger Govier]

Hi Trish

To prevent the "roll-over" at 24 hours, format your Total cell as [h]:mm

 

[Gary Brown]

Change the format of the total cell from 'h:mm'
to 'dd:hh:mm'.