calculating time

[shazbat61]

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

 

[Niek Otten]

Format Custom as [h]:mm

--
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

 

[Kevin B]

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

 

[shazbat61]

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

 

[Fred Smith]

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.