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

Hi!

You can manually enter time values up to 9999:59, above that they are
automatically evaluated as GENERAL TEXT values.

You can calculate time values well in excess of 9999:59

A1 = 9999:59
A2 = 9999:59

=SUM(A1:A2)

Returns 19999:58

Biff

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