Excel add subtract any hours minutes [HHHHHH]:m inc negative

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This one is for the Aviation Field, specifically Engineering Maintenance
Planning.
Many components are lifed by tens of thousands of hours. The need is to add
and subtract just the hours and minutes without having to use INT MOD TRUNC
or Date conversions. ie 30099:59 + 10000:01 or 25:59 - 30:01 using the same
formula. Any combination of hours no matter how large or small or negative
should add in the same way.
To be able to see if any negative hours and minutes exist ie components past
life.
Excel for some strange reason always relates the addition and subtraction of
hours to Dates.

Excel should be much more Engineer friendly and with standard engineering
functions. Wasting time trying to make a formula to add and subtract tens of
thousands of hours when [HHHHHH]:mm should be a valid format.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...9d85f400&dg=microsoft.public.frontpage.client
 
you might want to hop over to the Excel newsgroup...I think you'll get a better answer there.


| This one is for the Aviation Field, specifically Engineering Maintenance
| Planning.
| Many components are lifed by tens of thousands of hours. The need is to add
| and subtract just the hours and minutes without having to use INT MOD TRUNC
| or Date conversions. ie 30099:59 + 10000:01 or 25:59 - 30:01 using the same
| formula. Any combination of hours no matter how large or small or negative
| should add in the same way.
| To be able to see if any negative hours and minutes exist ie components past
| life.
| Excel for some strange reason always relates the addition and subtraction of
| hours to Dates.
|
| Excel should be much more Engineer friendly and with standard engineering
| functions. Wasting time trying to make a formula to add and subtract tens of
| thousands of hours when [HHHHHH]:mm should be a valid format.
|
| ----------------
| This post is a suggestion for Microsoft, and Microsoft responds to the
| suggestions with the most votes. To vote for this suggestion, click the "I
| Agree" button in the message pane. If you do not see the button, follow this
| link to open the suggestion in the Microsoft Web-based Newsreader and then
| click "I Agree" in the message pane.
|
| http://www.microsoft.com/office/com...9d85f400&dg=microsoft.public.frontpage.client
 
Back
Top