Prev: Need to bring back 2 vlookup values
Next: Explain INDEX MATCH
From: Trish on 6 Apr 2010 13:26
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



From: Roger Govier on 6 Apr 2010 13:48
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
>
>
>
From: Gary Brown on 6 Apr 2010 13:58
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
>
>
>
 | 
Pages: 1
Prev: Need to bring back 2 vlookup values
Next: Explain INDEX MATCH