As reported elsewhere, that is 31st December 9999 23:59.
--
David Biddulph

"Sandy Mann" wrote in message
...
[h]:mm is a number format. It does not have the limit you specify.

The display limit in XL97 seems to be 71003183:59

Which is of no interest to anyone other than the de Havilland Tiger Moth
that I learned to fly in <g

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Tom Ogilvy" wrote in message
...
[h]:mm is a number format. It does not have the limit you specify. Put
500
in a cell and format it as [h]:mm. What does have a limit is an entry
like

10000:00

then as you say, it is not interpreted as a time value. This isn't
changeable.

--
Regards,
Tom Ogilvy




"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