Excel formulas

[Guest]

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.

 

[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

 

[Guest]

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

And what are the formula?