Thanks, Steve. I tested XL2003 and it did exactly what you wrote. It
confirmed my opinion that this is a very stupid and unnecessary limitation!

Regards,
Stefi


€žSteveW€� ezt Ã*rta:

I *always* try out the stuff before I post.
Didn't save the test book though, and when I tried it again

I can't either, but if you type 9999:00 into a cell and drag it
down one it will put 10000:00 into the cell
displaying as 19/02/1901 16:00:00 if you click on the formula bar

Sorry for the confusion, I did think I had typed it in rather than
calculated it.
But I did get it into a cell without using a formula :)

Steve



On Thu, 22 Feb 2007 09:43:28 -0000, Stefi
wrote:

Hi Steve,

How did you find this information? I tried also in XL2000, and I found,
that
entering 10000:00 results in a text instead if time value just like in
XL2003!

Regards,
Stefi


€žSteveW€� ezt Ã*rta:

XL2000 doesn't have this limit
not on inputted or calculated values

Steve


On Thu, 22 Feb 2007 08:19:13 -0000, Stefi
wrote:

Thanks to all of you for your posts, they fully cleared the question
for
me!
Nevertheless I still think that this is a stupid limit!

Regards,
Stefi


€žStefi€� ezt Ã*rta:

Hi All,

[h]:mm time format seems to work only up to 9999 hours, XL2003
doesn't
handle 10000 hours as time, 10000:00 remains text. Is this an
unchangeable
limit?

Thanks,
Stefi





--
Steve (3)