I need to math manipulate figs over 10,000( in hrs & min format)?

[Guest]

I work with aircraft and log flying hours to servicings. I use a custom
format of "[h]:mm" working in hours and minutes. I need to add and subtract
these figures in the main, but some exceed 10,000 hrs and are not recognised
by excel. How do I get round this.
Please can someone help. All data is entered into cells due to the amount of
different aircraft. At least 5 servicings per AC at fixed flying times. I
need to log the times to ensure I dont fly the AC when they are due SVG.ie
SVG due @ 12000hrs. AC flown 9876:45 plus another 50:00 hrs. Hrs remain to
service are?

 

[Niek Otten]

In my version of Excel (XP) there is no problem with calculations >10,000
hours. AFAIK, there have not been any significant changes in time
calculation in the last few versions.
What makes you think "are not recognised by excel"?

 

[Guest]

Can you change the whole thing to decimal hours? Or maybe just round?

In my version of Excel (XP) there is no problem with calculations >10,000
hours. AFAIK, there have not been any significant changes in time
calculation in the last few versions.
What makes you think "are not recognised by excel"?

--
Kind regards,

Niek Otten

I work with aircraft and log flying hours to servicings. I use a custom
format of "[h]:mm" working in hours and minutes. I need to add and
subtract
these figures in the main, but some exceed 10,000 hrs and are not
recognised
by excel. How do I get round this.
Please can someone help. All data is entered into cells due to the amount
of
different aircraft. At least 5 servicings per AC at fixed flying times. I
need to log the times to ensure I dont fly the AC when they are due SVG.ie
SVG due @ 12000hrs. AC flown 9876:45 plus another 50:00 hrs. Hrs remain to
service are?