Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
heliheadache
 
Posts: n/a
Default 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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM
Time - Hours and Minutes Mark Zak Excel Discussion (Misc queries) 4 February 18th 05 02:51 AM
count TIME that is GREATER than 24 hours JonPilot Excel Worksheet Functions 1 January 31st 05 11:55 PM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 07:07 PM
in excel totaling weekly hours military time mel Excel Worksheet Functions 1 January 17th 05 05:24 PM


All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"