using time functions when hours are greater than 10000

[heliheadache]

I use excel to track operational time of equipment. I track hours and
minutes. Some of the equipment I am tracking has acculmilated over 10000 hrs
and excel formulas no longer produce a result. The result is '#VALUE!'.

 

[Bob Phillips]

I just did a little test and filled A1:A500 with 23:00 in each cell and
summed it and got 11,500 ok. It must be something else I feel.

--

HTH

RP
(remove nothere from the email address if mailing direct)