View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Time (gentlemen, please)

"Jock" wrote...
I'm trying to add up a column of times (format/custom hh:mm) however,
when 24 hours is reached and exceeded, the results start at 00:00 again
rather than just continuing to add up. How can I get around this?


Give that cell the number format "[h]:mm:ss". The seconds portion is
optional, but the hour portion needs the square brackets.