LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!'.
 
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 01:51 AM
count TIME that is GREATER than 24 hours JonPilot Excel Worksheet Functions 1 January 31st 05 10:55 PM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 06:07 PM
in excel totaling weekly hours military time mel Excel Worksheet Functions 1 January 17th 05 04:24 PM


All times are GMT +1. The time now is 06:31 PM.

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

About Us

"It's about Microsoft Excel"