Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding time in hours
I am trying to keep a rolling total of aircraft flight hours. When the base
hours is greater than 10000:00 excel will not add the next days total. It seems that the base hours need to be equal to or less than 9999:00, however many of the aircraft have done more that 10000:00 hours -- Jono Blowes |
#2
|
|||
|
|||
LOL. Many CREW have done more than 10,000 also, right? Why don't you just
format the result as numbers instead of as time? ************ Anne Troy www.OfficeArticles.com "Jono" wrote in message ... I am trying to keep a rolling total of aircraft flight hours. When the base hours is greater than 10000:00 excel will not add the next days total. It seems that the base hours need to be equal to or less than 9999:00, however many of the aircraft have done more that 10000:00 hours -- Jono Blowes |
#3
|
|||
|
|||
Jono,
This is an Excel oddity, and I found that as long as you keep below 10000 for the base number, you can continue adding it without problem. So, you can work around it. -- HTH Bob Phillips "Jono" wrote in message ... I am trying to keep a rolling total of aircraft flight hours. When the base hours is greater than 10000:00 excel will not add the next days total. It seems that the base hours need to be equal to or less than 9999:00, however many of the aircraft have done more that 10000:00 hours -- Jono Blowes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
Time - Hours and Minutes | Excel Discussion (Misc queries) | |||
adding time zones to formatting | Excel Worksheet Functions |