How do I add time abouve 10000 hours in excel?
Hi!
You can enter up to 9999:59:59 in a cell and Excel will recognize it as a
time format.
10000:00 would default to a GENERAL format as a text entry.
The Sum function works on totals well beyond 10000:00.
Biff
"Byron" wrote in message
...
I am adding times in excel, and everything is fine until I get above 10,000
hours. The sum feature in the program will not allow additions above
10,000,
or at least it will not add them correctly. Anyone have a solution?
|