I'm wanting a formula where I can calculate leg time for a Flight Planner
log sheet.
EXAMPLE:
Distance (5 Miles)
Ground speed (76 knots per hour)
PROBLEM:
The correct answer is 3:56, however, I don't know how to get this using
an excel formula.
That answer is only correct if you actually mean '76 MILES per hour' or '5
KNOTS': i.e. only if the distance units are the same. If you also have to
deal with two types of units - statute miles (5280 ft.) and knots (6076 ft.)
- then you'll need to convert one to the other as well. For now I'll assume
you are using either statute or nautical (knot) miles consistently.
In column A enter 5.
In column B enter 76.
In column C enter =(A1/B1)/24
and press return. Select C1.
In Format/Cells, choose Custom | mm:ss if you really want just minutes and
seconds (03:57) or enter your own custom format "m:ss" (no quotes) if you
really don't want the leading zero (3:57). If you want hours as well, should
it go over an hour, you'd need h:mm:ss - which is the same as Time |
37:30:55
Choosing any of these time formats converts a number as if it were a
fraction of a day into the time format you choose. Since your distance in
miles / speed in miles per hour gives a result in terms of hours you need to
divide by 24 to get it as a fraction of a day.
To apply this formula to a set of values in columns A and B, apply that
same Time or Custom choice in Format/Cells to the whole of column C after
selecting it. After entering all your data in columns A and B, select column
C down as far as A and B have data and pick Edit/Fill/Down.
--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <
http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <
http://macscripter.net/scriptbuilders/>
Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.
PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
