Calculating Time?
 

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

Calculating Time?
 

Hi Trish

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

--
Regards
Roger Govier

Trish wrote:
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

Calculating Time?
 

Change the format of the total cell from 'h:mm'
to 'dd:hh:mm'.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Trish" wrote:

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