There are probably neater ways of doing this, but this does work

You will need to create a table with each time increment from midnight
to 23:55 from A6 expressed as time 00:00, 00:05, 00:10 etc. In the
next column (from B6)these need to be expressed as decimal numbers with
at least 4 numbers after the decimal: 0.000, 0.0035, 0.0069, 0.0104 etc.
You can do this by starting with one cell in B3 with 5 minutes as a
decimal in it (0.003472) and just mulitply it up. These two columns are
going to become your look up table.
Next thing is to set up your Take off and Landing times either one
under the other or side by side (in this example they are one under the
other) Enter these as times: 12:00 and 12:59. Set the next column to
read these two numbers ( =E3) if the time is in D3, but format it in
decimal not time. Perform the calculation of subtracting the landing
time from the takeoff time in column E using the time notation. You
will end up with 0:59. Under the the take off and landing times in
column D you will need to set a lookup formula to look at the answer in
ColE and compare it with the lookup table. The formula you'll need is
=vlookup(e8,a6:b293,2)+b3. This will find the nearest decimal under
0:59 which is 0.0382 and add another 5 minutes to it


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=393277