Adding time in hours

J

Jono

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
 
B

Bob Phillips

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.
 
Top