Thanks Toppers, I've made a workaround with UDFs, but it's really a stupid
limit! I came across such large numbers of hours in reporting flight hours of
airplanes, which is quite a normal task, there is nothing exceptional in it!

Regards,
Stefi


€žToppers€� ezt Ã*rta:

Stefi,
I tried the following with cells formatted as [h]:mm

I entered 9999:00 in row 1 and then copied down: all cells looked OK and a
SUM also looked OK. If I overtyped a value 9999 then I had your result i.e.
time now appeared as text!

A bug ???

I don't have an answer!


"Stefi" wrote:

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