IIRC, you can't directly enter a number in either format greater than

9999:59:59

But you can use the format for much bigger numbers. Experimentally, I
get the formats turning to ####s when the value is greater than

2957003.99999

which corresponds to

70968095:59



In article ,
"Biff" wrote:

Hi folks!

Using these formats:

[h]:mm
[hh]:mm

Does anyone know the exact limits on hours before each
will fail?

I'm thinking that the limit for [hh]:mm is 9999 hrs, but
I'm not sure. And for [h]:mm, I don't know this one.