using time functions when hours are greater than 10000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top