[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