Specs of formats

B

Biff

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.

Thanks!

Biff
 
J

JE McGimpsey

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
 
B

Biff

Thanks, JE.

Yes, I've discovered that if you directly enter 10000:00
then the cell format will default to general text.

I wanted to know at what point a sum formula would fail. I
experimented up to 99999:00.

Biff
-----Original Message-----
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



Biff said:
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.
Click to expand...
.
Click to expand...
 
Top