Hours over 10000:00

[Guest]

Has anyone figured out how to use hours over 9999:59. i am trying to use
Excel for adding times of aircraft, and some of our planes have over 10000
hours on them, but I cannot figure out how to enter a hour over 9999:59.
It's probably not possible, but I thought I would throw it out there and see
if anyone on the A-team devised an add-on or formule, ect in order to make
this happen. The funny thing is, I can add 2 #s, like 9000:00 and 9000:00
and it will give me 18000:00, no problem, so I know it knows what i am
wanting to do, but If I manually enter 18000:00 for example, it dumbs up and
just give me a #value error message in the cell. Thanks in advance for any
help you might be able to offer.

miles reed

 

[Max]

Perhaps a workaround might be to
simply enter the hours as numbers
(e.g.: "10.5" means "10:30" viz. 10 hours and 30 mins)

and use an adjacent col to show the "results" as [h]:mm

Example:

Put

in A1: 9999.5 (== 9999:30)
in A2: 12000.5 (== 12000:30)
in A3: =SUM(A1:A2)

Put in B1: =TEXT(A1/24,"[h]:mm")
Copy B1 down to B3