View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default How do I process hours greater than 24

Use a format like:
[h]:mm

Regards,
Fred

"dixr" wrote in message
...
Doing a timesheet application, how to I add up the hours when they exceed
24
hours? The same issue would come up in a project management application
when
the project will exceed 24 hours. I need to have hours up to thousands.
The
applications need to keep fractional hours in minutes - hhhh:mm