Excel formulas

M

Marie 76

I have an excel 2003 document with 12 pages of all employees listing the
hours and
minutes used on each job. I have a grand total at the end, but for some
reason when I tell excel to add the times together the figures don't match to
what I have added manually. I'm not sure if I have the cell formatted wrong
or it's the total - I truly could use some expert help to the novice to
excel. Does excel round up? Any suggestions would be greatly appreciated.
 
P

Peo Sjoblom

Use custom format [hh]:mm if you use time format, or it will not roll over
24 hours so a total of 30:00 will display as 06:00 if you use hh:mm
 
T

Toppers

If times are hh:mm then make TOTAL format [hh]:mm to stop Excel reverting to
zero if > 24.

And what are the formula?
 
Top