10000+ Hours in Time format

[Ajesh]

Hi Everyone,

Is there a way to enter 10000+ hours in time format.

Everything remaims cool uptill 9999:59:59 but 10000:00:00 hours or more is treated as text value by excel.

 

[NARAYANK991]

Hi Ajesh ,

You can put the value 9999:59:59 in a cell , and then you can use the formula :

=cell + TIMEVALUE("00:00:01")

to get the value equivalent to 10000:00:00

Narayan

 

[Hui]

Yes there is a 1 second less than 10,000 Hr limit on Excel times
http://support.microsoft.com/kb/214386

If you want to enter values greater than 10,000 hrs enter them as text strings
Then do the math with formulas and add them Hrs, Mins and Secs together
eg:

See attached file:

 

[Ajesh]

Hi Narayan,

This is what i am doing currently. I was looking for something which stores it in Time format in the first place. We need to frequently import/copy-paste data which contains values 10K+ hours and then perform further calculations based on them. For this it requires to find those mischievous values and give them a spanking with help of TIMEVALUE function.

Not sure if this is a bug with Excel or something else.

 

[Ajesh]

Ah! there it is. Thanks Hui.

Wonder why would Microsoft think that time values should not be greater than 9999:59:59.