Thread: Excel formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.