Thread
:
Excel formulas
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
external usenet poster
Posts: 3,268
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.
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom