View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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?