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
|