View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Time (gentlemen, please)

Thanks Pete
--
Traa Dy Liooar

Jock


"Pete_UK" wrote:

Format the cell with the SUM in it using Custom, as [hh]:mm. The
square brackets around the hh tell excel not to wrap hours above 24.

Hope this helps.

Pete

On Aug 14, 4:00 pm, 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?
Thanks

--
Traa Dy Liooar

Jock