Search results
3 paź 2020 · Re: Calculate flight distance in miles between any 2 cities. to do this, you need a table of distances / map references between multiple locations which I assume is what is behind the web calculator but available to you (or us!). See attached with sample formula in B34.
27 cze 2023 · In this case, we’ll use the formula =IF (K2>F2, K2-F2,1+K2-F2). K2 is the cell containing “Arrival Time in GMT” and F2 is the cell containing “Departure Time in GMT”. Write the formula in the “Total flight time column”. Drag the AutoFill Handle to calculate Flight Time for all flights.
Based on some quick research on basic flight calculations, a 727 going 542 Knots for a distance of 530 NM (Nautical Miles), that flight should be 58 minutes, not 1 hour and 58 minutes. Every calculation I've done on the 727, 737 and DC9 comes up under (in some cases, waaaaay under) the game's time versus the typical flight calculation....
15 mar 2011 · Give this formula a try... =90*A1/A2/132 where A1 is your distance in feet and A2 is your speed in miles per hour.
21 lut 2006 · I'm setting up a trip spreadsheet and would like to include a column to estimate expected time to travel. I have a column for distance from Point A to Point B. What I'd like to do is be able to divide by my expected rate of travel (72 mph) to determine expected time from A to B.
9 cze 2024 · Step 1: Determine Mileage. Insert an additional column for Mileage. Type in the ROUNDUP function to round up the result to one decimal place. Enter the following formula below: =ROUNDUP(E5/F5,1) In this expression, the E5 cell refers to the Distance ( number argument) in miles while the F5 cell indicates the Fuel in US gallons ( number argument).
14 cze 2018 · Here is the formula in cell C5: =IFERROR (INDEX ($H$4:$Q$13, MATCH (B4,$G$4:$G$13,0), MATCH (B5,$H$3:$Q$3,0)),””) The INDEX function returns a value from H4:Q13 (outlined in blue) The first MATCH function returns the row of the first city (in B4), from the vertical list of cities in G4:G13 (purple)
