How to input a number of hours greater than 9999?

[gerard_opio]

Hello,

I have a spreadsheet where I log the used time of plane' parts.
The cell format is [h]:00
Everything works fine until I try to enter an hour value of 10235:00 > the value was accepted as text!
I found that the maximum value I can type is 9999:00.
The sum of cells can be greater than 10000:00 and it works fine!
It means it is just an input issue.

Excel is version 2003 SP3.

Have some comments?

Gerard

 

[MarkVMcCullagh]

Microsoft mention it as a limit on http://support.microsoft.com/kb/214386

 

[pgc01]

Hi Gerard
Welcome to the board

To enter a number of hours bigger than the limit 9999, enter it as number.

Ex.:

1- to enter 10235:00, enter

=10235/24

2- to enter 10235:23

=10235/24 + "0:23"

and format the cells as [h].mm

 

[gerard_opio]

Thanks for your assistance!
The workaround works fine for me!

Gerard