Spreadsheet: 760503d1640254969-calculating-elaspsed-time-between-two-time-cells-in-different-time-zones-flights2021_final
Sheet: IATA

Code | Link | Airport | Country | [NAME]
AAL | Aalborg Airport | Aalborg | Denmark | 0
ABZ | Aberdeen Dyce Airport | Aberdeen | United Kingdom | 1
AER | Sochi International Airport | Sochi | Russia | 0
AGP | [NAME] | Málaga | Spain | 0
AKT | RAF Akrotiri | Akrotiri | United Kingdom | 1
ALC | Alicante International Airport | Alicante | Spain | 0
AMS | Amsterdam Airport Schiphol | Amsterdam | The Netherlands | 0
ARN | Stockholm Arlanda Airport | Stockholm | Sweden | 0
ATH | Athens International Airport "Eleftherios [NAME] | Athens | Greece | 0
BCN | Barcelona–El Prat Airport | Barcelona | Spain | 0
BEG | Belgrade Nikola Tesla Airport | Belgrade | Serbia | 0
BER | Berlin Metropolitan Area | Berlin | Germany | 0
BFS | Belfast International Airport | Belfast | United Kingdom | 1
BGO | Bergen Airport Flesland | Bergen | Norway | 0
BGY | Il Caravaggio International Airport | Bergamo | Italy | 0 |  |  |  | 08:01:00
BHD | [NAME] City Airport | Belfast | United Kingdom | 1
BHX | Birmingham International Airport | Birmingham | United Kingdom | 1
BLL | Billund Airport | Billund | Denmark | 0
BLQ | [NAME] | [NAME] | Italy | 0
BOD | Bordeaux-Mérignac Airport | Bordeaux | France | 0
BOH | Bournemouth Airport | Bournemouth | United Kingdom | 1
BOJ | Burgas Airport | Burgas | Bulgaria | 0
BOO | Bodø Airport | Bodø | Norway | 0
BRE | Bremen Airport | Bremen | Germany | 0
BRI | Bari Karol Wojtyła Airport | [NAME] | Italy | 0
BRS | Bristol Airport | Bristol | United Kingdom | 1
BRU | Brussels Airport | Brussels | Belgium | 0
BSL | EuroAirport Basel-Mulhouse-Freiburg Airport | Bâle/Mulhouse | France | 0
BTS | [NAME] | Bratislava | Slovakia | 0
BUD | Budapest Liszt Ferenc International Airport | Budapest | Hungary | 0
BVA | Beauvais–Tillé Airport | Paris | France | 0
BZZ | RAF Brize Norton | Brize Norton | United Kingdom | 1
CAG | [NAME] | Cagliari | Italy | 0
CDG | Paris-Charles de Gaulle Airport | Paris | France | 0
CGN | Cologne Bonn Airport | Cologne | Germany | 0
CIA | Rome–Ciampino International Airport "[NAME]" | Rome | Italy | 0
CPH | Copenhagen Kastrup Airport | Copenhagen | Denmark | 0
CRL | Brussels South Charleroi Airport | Brussels | Belgium | 0
CTA | Catania-Fontanarossa Airport | Catania | Italy | 0
CWL | Cardiff International Airport | Cardiff | United Kingdom | 1
DME | Domodedovo International Airport | Moscow | Russia | 0
DRS | Dresden Airport | Dresden | Germany | 0
DSA | [NAME] Sheffield Airport | Doncaster | United Kingdom | 1
DTM | Dortmund Airport | Dortmund | Germany | 0
DUB | Dublin Airport | Dublin | Ireland | 1
DUS | [NAME] | [NAME] | Germany | 0
EDI | [NAME] | Edinburgh | United Kingdom | 1
EIN | [NAME] | Eindhoven | The Netherlands | 0
EMA | East Midlands Airport | [NAME] | United Kingdom | 1
EXT | Exeter International Airport | Exeter | United Kingdom | 1
FAO | [NAME] | Faro | Portugal | 1
FCO | Rome–Fiumicino International Airport "[NAME]" | Rome | Italy | 0
FEZ | Fès–Saïss Airport | Fez | Morocco | 0
FFD | RAF Fairford | Fairford | United Kingdom | 1
FKB | [NAME] | Baden-Baden | Germany | 0
FMO | [NAME] | Münster | Germany | 0
FRA | Frankfurt am Main Airport | Frankfurt am Main | Germany | 0
FUE | [NAME] | [NAME] | Spain UTC | 0
GDN | Gdańsk Lech Wałęsa Airport | Gdańsk | Poland | 0
GLA | Glasgow International Airport | [NAME] | United Kingdom | 1
GOA | Genoa Cristoforo Colombo Airport | Genova | Italy | 0
GOT | Gothenburg-Landvetter Airport | Gothenburg | Sweden | 0
GRV | [NAME] | Grozny | Russia | 0
GVA | Geneva Airport | Geneva | Switzerland | 0
HAJ | Hannover Airport | Hannover | Germany | 0
HAM | Hamburg Airport | Hamburg | Germany | 0
HEL | [NAME] | Helsinki | Finland | 0
HER | Heraklion International Nikos Kazantzakis Airport | Heraklion | Greece | 0
HRK | Kharkiv International Airport | Kharkiv | Ukraine | 0
IBZ | [NAME] | Ibiza | Spain | 0
KBP | Boryspil International Airport | Kiev | Ukraine | 0
KEF | Keflavik International Airport | Reykjavík | Iceland | 1
KJA | Yemelyanovo Airport | Krasnoyarsk | Russia | 0
KRK | [NAME] International Airport | [NAME] | Poland | 0
KTW | Katowice International Airport | Katowice | Poland | 0
KUF | Kurumoch International Airport | Samara | Russia | 0
KZN | Kazan International Airport | Kazan | Russia | 0
LBA | [NAME] | Leeds | United Kingdom | 1
LED | Pulkovo Airport | St. Petersburg | Russia | 0
LEJ | Leipzig/Halle Airport | Leipzig | Germany | 0
LGG | Liège Airport | Liège | Belgium | 0
LGW | [NAME] | London | United Kingdom | 1
LHR | London Heathrow Airport | London | United Kingdom | 1
LIN | Milano Linate Airport | Milan | Italy | 0
LIS | [NAME] (Lisbon Portela Airport) | Lisbon | Portugal | 1
LJU | [NAME] | Ljubljana | Slovenia | 0
LKZ | [NAME] | Lakenheath | United Kingdom | 1
LLA | Luleå Airport | Luleå | Sweden | 1
LPA | [NAME] | [NAME] | Spain UTC | 1
LPL | Liverpool [NAME] | Liverpool | United Kingdom | 1
LTN | London Luton Airport | London | United Kingdom | 1
LUX | Luxembourg-Findel International Airport | Luxembourg | Luxembourg | 0
LYS | [NAME]Exupéry Airport | Lyon | France | 0
MAD | Adolfo [NAME]–Barajas Airport | Madrid | Spain | 0
MAH | Menorca Airport | Menorca | Spain | 0
MAN | [NAME] | [NAME] | United Kingdom | 1
MHZ | [NAME] | Mildenhall | United Kingdom | 1
[NAME] | Malta International Airport | Valletta | Malta | 0
MMX | [NAME] | Malmö | Sweden | 1
MRS | Marseille Provence Airport | Marseille | France | 0
MSQ | Minsk National Airport | Minsk | Belarus | 0
MUC | Munich Airport | Munich | Germany | 0
MXP | Malpensa International Airport | Milan | Italy | 0
NAP | Naples International Airport | Nápoli | Italy | 0
NCE | Nice-Côte d'Azur Airport | Nice | France | 0
NCL | Newcastle Airport | Newcastle | United Kingdom | 1
NDR | Nador International Airport | Nador | Morocco | 0
NUE | Nuremberg Airport | Nuremberg | Germany | 0
NWI | Norwich International Airport | [NAME] | United Kingdom | 1
NYO | Stockholm Skavsta Airport | Stockholm | Sweden | 0
ODS | Odessa International Airport | Odessa | Ukraine | 0
OPO | [NAME] | Porto | Portugal | 1
ORK | [NAME] | Cork | Ireland | 1
ORY | Paris-Orly Airport | Paris | France | 0
OSL | Oslo Gardermoen Airport | Oslo | Norway | 0
OTP | Bucharest Henri Coandă International Airport | Bucharest | Romania | 0
OUD | Oujda Angads Airport | Oujda | Morocco | 0
PDL | [NAME] | Ponta Delgada | Portugal | 1
PIC | [NAME] | [NAME] | United Kingdom | 1
PMI | Palma De Mallorca Airport | [NAME] | Spain | 0
PMO | Falcone–Borsellino Airport | Palermo | Italy | 0
POZ | Poznań-Ławica Airport | Poznań | Poland | 0
PRG | [NAME] Prague | Prague | Czechia | 0
PRN | Priština International Airport | Prishtina | Kosovo | 0
PSA | Pisa International Airport | Pisa | Italy | 0
RAK | [NAME] | Marrakech | Morocco | 0
RBA | Rabat–Salé Airport | [NAME] | Morocco | 0
RIX | Riga International Airport | Riga | Latvia | 0
RMS | Ramstein Air Base | Ramstein | Germany | 0
ROV | Platov International Airport | Rostov-on-Don | Russia | 0
SCQ | Santiago de Compostela Airport | Santiago de Compostela | Spain | 0
SDR | [NAME] | Santander | Spain | 0
SIP | Simferopol International Airport | Simferopol | Ukraine | 0
SJJ | Sarajevo International Airport | Sarajevo | Bosnia and Herzegovina | 0
SKG | Thessaloniki Macedonia International Airport | Thessaloniki | Greece | 0
SKP | Skopje Alexander the Great Airport | Skopje | Macedonia | 0
SNN | Shannon Airport | Shannon | Ireland | 1
SOF | Sofia Airport | Sofia | Bulgaria | 0
SOU | Southampton Airport | Southampton | United Kingdom | 1
SPC | [NAME] | [NAME], La Palma Island | Spain | 0
STN | London Stansted Airport | London | United Kingdom | 1
STR | Stuttgart Airport | Stuttgart | Germany | 0
SVG | Stavanger Airport Sola | Stavanger | Norway | 0
SVO | Sheremetyevo International Airport | Moscow | Russia | 0
SVQ | Seville Airport | Seville | Spain | 0
SXF | Berlin-Schönefeld Airport | Berlin | Germany | 0
TER | [NAME] | [NAME] | Portugal | 0
TFN | [NAME] | Tenerife Island | Spain UTC | 1
TFS | Tenerife South Airport | Tenerife Island | Spain UTC | 1
TGD | Podgorica Airport | Podgorica | Montenegro | 0
TIA | Tirana International Airport Mother Teresa | Tirana | Albania | 0
TLL | Tallinn Airport | Tallinn | Estonia | 0
TLS | Toulouse-Blagnac Airport | Toulouse/Blagnac | France | 0
TOS | Tromsø Airport | Tromsø | Norway | 0
TRD | [NAME] Værnes | Trondheim | Norway | 0
TRN | Turin Airport | Turin | Italy | 0
TSF | Treviso-Sant'Angelo Airport | Treviso | Italy | 0
TXL | Berlin-Tegel Airport | Berlin | Germany | 0
UFA | Ufa International Airport | Ufa | Russia | 0
VAR | Varna Airport | Varna | Bulgaria | 0
VCE | Venice [NAME] | Venice | Italy | 0
VIE | Vienna International Airport | Vienna | Austria | 0
VKO | Vnukovo International Airport | Moscow | Russia | 0
VLL | [NAME] | Valladolid | Spain | 0
VNO | Vilnius International Airport | Vilnius | Lithuania | 0
VRN | [NAME] | [NAME] | Italy | 0
WAW | Warsaw Chopin Airport | Warsaw | Poland | 0
WMI | [NAME] | Warsaw | Poland | 0
WRO | Copernicus Airport Wrocław | Wrocław | Poland | 0
XRY | [NAME] | [NAME] | Spain | 0
ZAG | [NAME] | Zagreb | Croatia | 0
ZIA | Zhukovsky International Airport | Moscow | Russia | 0
ZRH | [NAME] | Zurich | Switzerland | 0