Specs of formats
 

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

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.

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



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.
.