View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default calculate the sum of hours exceeding 23:56

Just add as usual, use a custom format of [hh]:mm otherwise it won't display

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"charllie" wrote in message
...
tell me how to add the sum of hours together which exceed 23:59