How do I add time abouve 10000 hours in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
So, are saying I need to change the format of the cells to GENERAL?

No!

If you manually enter a time in a cell Excel will recognize it as such up to
a value of 9999:59:59. That's it! Anything manually entered above 9999:59:59
will be treated as GENERAL format text.

You can have formulas that calculate time well beyond 10000:00 hrs.

Enter 9999:00 in 100 cells. A SUM formula will return 999990:00 (formatted
as [h]:mm).
The sum feature in the program will not allow
additions above 10,000
Click to expand...

What does that mean?

Biff
 
Back
Top