Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!'. |
#2
|
|||
|
|||
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!'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Time - Hours and Minutes | Excel Discussion (Misc queries) | |||
count TIME that is GREATER than 24 hours | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
in excel totaling weekly hours military time | Excel Worksheet Functions |