using time functions when hours are greater than 10000
 

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

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)


"heliheadache" wrote in message
...
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!'.