calculating time
 

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

calculating time
 

Format Custom as [h]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"shazbat61" wrote in message ...
|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

calculating time
 

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


"shazbat61" wrote:

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

calculating time
 

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

"Kevin B" wrote:

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


"shazbat61" wrote:

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

calculating time
 

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.

"shazbat61" wrote in message
...

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

"Kevin B" wrote:

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


"shazbat61" wrote:

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