Adding Hours & Minutes
Everything looks correct. What is your formula returning? Is it returning a
zero, or just some number that doesn't agree with what you think it should be?
Possible problems:
Are your formulas, for some reason, returning a text value thus causing SUM
to = 0?
What are the floating 5's in your example for?
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Tina" wrote:
I am adding a large column of hours and need a total for the end of the
month.
0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
00:00
I have formulas in the cells above to calculate the number of hours when an
employee enters their time.
I can't get it to give me a correct value of the hours and minutes. This is
what my formula looks like: =SUM(E12:E37)
The cell is formatted to this: [hh]:mm
|