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

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?

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

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

"ATECH" wrote in message
...
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?

I need to math manipulate figs over 10,000( in hrs & min forma
 

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

"Niek Otten" wrote:

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

"ATECH" wrote in message
...
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?