Need distance between airport codes

[djl0525]

I'm making a spreadsheet to calculate air miles for domestic and international travel. The start and end points are entered as airport codes. To date, I have been looking up the mileage at a few sites like www.webflyer.com. But this project has grown and now I need to calculate without opening a web page. I need Excel to do all the calculation.

Does anyone know of an Add-In or Excel database that calculates the distance between cities or airport codes?

FYI: I tried making a web query to webflyer.com, but the site's calculations are displayed on a page different than the inputs.

Thank you in advance for your consideration -- DJ

 

[VoG]

Can you get the grid references (Eastings and Northings) for the airports? If you can then you can calculate the distance between them using Pythagoras' Theorem.

 

[iliace]

I would suggest you use longitude/lattitude of each airport, and calculate the distance that way.

http://adds.aviationweather.noaa.gov/metars/stations.txthttp://www.realestate3d.com/gps/world-latlong.htm

Write a simple formula to convert long/lat to hours/minutes, then use lookups to get it by code, and a formula like ones described here:

http://www.cpearson.com/excel/latlong.htm

 

[djl0525]

Those are good ideas! I'll look into them.

Thanks!
DJ