S
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
from zero again like a 24 hour clock
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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
--
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
K
Kevin B
See Chip Pearson's Date/Time arithmetic web page at the following URL:
http://www.cpearson.com/excel/datearith.htm
http://www.cpearson.com/excel/datearith.htm
S
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
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
F
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.
Just follow his advice, and it will solve your problem.
Regards,
Fred.