calculating time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shazbat61 - 23 May 2008 19:32 GMT

i want to add up staff hours for the week but when it gets to 24 it starts
from zero again like a 24 hour clock

Reply to this Message

Niek Otten - 23 May 2008 19:39 GMT

Format Custom as [h]:mm

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|i want to add up staff hours for the week but when it gets to 24 it starts
| from zero again like a 24 hour clock

Reply to this Message

Kevin B - 23 May 2008 19:43 GMT

See Chip Pearson's Date/Time arithmetic web page at the following URL:
http://www.cpearson.com/excel/datearith.htm

Signature

Kevin Backmann

> i want to add up staff hours for the week but when it gets to 24 it starts
> from zero again like a 24 hour clock

Reply to this Message

shazbat61 - 23 May 2008 20:59 GMT

i tried that but its not working
i have 7:00 in cell b2
i have 11:00 in cell b3 = 4 hours thats is for monday in c 3
then i have the same in d 2 and d3 and e3 for tues
and so on for the week
i want to add up cells c3+e3+g3+i3+k3+m3+o3 = 28 hours but it is adding up
to 4 hours

> See Chip Pearson's Date/Time arithmetic web page at the following URL:
> http://www.cpearson.com/excel/datearith.htm
>
> > i want to add up staff hours for the week but when it gets to 24 it starts
> > from zero again like a 24 hour clock

Reply to this Message

Fred Smith - 24 May 2008 03:31 GMT

Niek Otten gave you the solution more than an hour before your second post.
Just follow his advice, and it will solve your problem.

Regards,
Fred.

> i tried that but its not working
> i have 7:00 in cell b2
[quoted text clipped - 10 lines]
>> > starts
>> > from zero again like a 24 hour clock

Reply to this Message