View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default add time greater than 9999:56

Use this technique, assume you have 35523 hours and you want to add 11450
hours to that, use

=(35523/24)+(11450/24)

or if you have the times in cells A2:A3

=SUM(A2:A3)/24

returns 46973:00:00 formatted as [hh]:mm:ss

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"PapaT" wrote in message
...
cells are formatted to [h]:mm and will not use a number higher than
9999:56