View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Time over 24 hours

Format Custom as [h]:mm

--
Kind regards,

Niek Otten

"CraigR53" wrote in message ...
I'm creating a custom timecard to compute time spent by a given employee on
various projects. When I try to add daily totals together to get weekly
totals and that total exceeds 23:59, I can't find a format that will display
it as such -- it always reduces it to a time under 23:59. (Example: 14:30 +
12:18 = 26:48, but it displays as 2:48) How can I fix this?