Can anyone help. I've heard that Excel is limited to calculating to a maximum
9,999:59 hours. Does anyone know how to overcome this without using decimal
hours and minutes. I work in the aircraft industry where the life is
calculated in hours and minutes and this can pose a problem for me. For
example, if an aircraft has used 9,900:30 hours and a component is changed
that has a life of 200:30 the aircraft hours that the new component is due
change is 10,101:00. Excel will not calculate this and only shows it as
'Value'. I need to show it in hours and minutes because people get confused
when they see decimal minutes 10.15 is taken as 10 hours 15 minutes and not
10 hours 25 minutes (10:25), this confusion can be critical.