Excel formulas
 

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.

Excel formulas
 

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


--
Regards,

Peo Sjoblom



"Marie 76" <Marie wrote in message
...
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.

Excel formulas
 

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

And what are the formula?

"Marie 76" wrote:

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.