View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Time (gentlemen, please)

On Tue, 14 Aug 2007 08:00:06 -0700, 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


Format/Cells/Number Custom Type: [hh]:mm


--ron