How do I add time abouve 10000 hours in excel?
 

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?

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?

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?

How do I add time abouve 10000 hours in excel?
 

So, are saying I need to change the format of the cells to GENERAL?

"Biff" wrote:

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?

How do I add time abouve 10000 hours in excel?
 

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

What does that mean?

Biff

"Byron" wrote in message
...
So, are saying I need to change the format of the cells to GENERAL?

"Biff" wrote:

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?