You can do it yourself. time is simply a number which counts seconds and
given in days

You can convert days to minute by multiplying by (24 * 60). then convert
this number to hours and minutes.

Use this formula
=CONCATENATE(TEXT(INT((F5*24*60)/60),"#"), ":",TEXT(MOD((F5*24*60),60),"#"))

"Tom Ogilvy" wrote:

[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