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

 |  |  |  | Total Flying Time
Date | Flight number | From | To | Dep time | Arr time | Duration | Airline | Aircraft | Registration | Seat number | Seat type | Flight class | Flight reason | Note | Dep_id | Arr_id | Airline_id | Aircraft_id
2021-11-29 00:00:00 | FR7541 | Barcelona / El Prat (BCN/LEBL) | Milan / Malpensa (MXP/LIMC) | 08:07:00 | 09:30:00 | 01:23:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-EGD |  | 0 | 5 | 3 |  | 239 | 1983 | 668 | 231
2021-11-29 00:00:00 | FR7540 | Milan / Malpensa (MXP/LIMC) | Barcelona / El Prat (BCN/LEBL) | 10:24:00 | 11:32:00 | 01:08:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-EGD |  | 0 | 0 | 3 |  | 1983 | 239 | 668 | 231
2021-11-29 00:00:00 | FR8384 | Barcelona / El Prat (BCN/LEBL) | Budapest / Franz Liszt International (BUD/LHBP) | 12:41:00 | 14:51:00 | 02:10:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-EGD |  | 0 | 0 | 3 |  | 239 | 429 | 668 | 231
2021-11-29 00:00:00 | FR8385 | Budapest / Franz Liszt International (BUD/LHBP) | Barcelona / El Prat (BCN/LEBL) | 15:05:00 | 17:40:00 | 02:35:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-EGD |  | 0 | 0 | 3 |  | 429 | 239 | 668 | 231
2021-11-30 00:00:00 | FR2834 | Barcelona / El Prat (BCN/LEBL) | Charleroi / Brussels South Charleroi (CRL/EBCI) | 14:01:00 | 15:49:00 | 01:48:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHZ |  | 0 | 0 | 3 |  | 239 | 615 | 668 | 231
2021-11-30 00:00:00 | FR2835 | Charleroi / Brussels South Charleroi (CRL/EBCI) | Barcelona / El Prat (BCN/LEBL) | 16:37:00 | 18:06:00 | 01:29:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHZ |  | 0 | 0 | 3 |  | 615 | 239 | 668 | 231
2021-11-30 00:00:00 | FR6985 | Barcelona / El Prat (BCN/LEBL) | Rome / Leonardo da Vinci-Fiumicino (FCO/LIRF) | 19:20:00 | 20:41:00 | 01:21:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHZ |  | 0 | 0 | 3 |  | 239 | 872 | 668 | 231
2021-11-30 00:00:00 | FR6986 | Rome / Leonardo da Vinci-Fiumicino (FCO/LIRF) | Barcelona / El Prat (BCN/LEBL) | 22:13:00 | 23:38:00 | 01:25:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHZ |  | 0 | 0 | 3 |  | 872 | 239 | 668 | 231
2021-12-03 00:00:00 | FR6374 | Barcelona / El Prat (BCN/LEBL) | Beauvais / Beauvais Tille (BVA/LFOB) | 06:54:00 | 08:36:00 | 01:42:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHT |  | 0 | 0 | 3 |  | 239 | 440 | 668 | 231
2021-12-03 00:00:00 | FR6375 | Beauvais / Beauvais Tille (BVA/LFOB) | Barcelona / El Prat (BCN/LEBL) | 09:25:00 | 10:39:00 | 01:14:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHT |  | 0 | 0 | 3 |  | 440 | 239 | 668 | 231
2021-12-03 00:00:00 | FR9111 | Barcelona / El Prat (BCN/LEBL) | Torino / Caselle (TRN/LIMF) | 11:53:00 | 13:09:00 | 01:16:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHT |  | 0 | 0 | 3 |  | 239 | 3008 | 668 | 231
2021-12-03 00:00:00 | FR9112 | Torino / Caselle (TRN/LIMF) | Barcelona / El Prat (BCN/LEBL) | 14:12:00 | 15:10:00 | 00:58:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DHT |  | 0 | 0 | 3 |  | 3008 | 239 | 668 | 231
2021-12-04 00:00:00 | FR3037 | Barcelona / El Prat (BCN/LEBL) | Luxembourg / Luxembourg (LUX/ELLX) | 14:30:00 | 16:13:00 | 01:43:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DYA |  | 0 | 0 | 3 |  | 239 | 1716 | 668 | 231
2021-12-04 00:00:00 | FR3038 | Luxembourg / Luxembourg (LUX/ELLX) | Barcelona / El Prat (BCN/LEBL) | 16:55:00 | 18:32:00 | 01:37:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DYA |  | 0 | 0 | 3 |  | 1716 | 239 | 668 | 231
2021-12-08 00:00:00 | FR2918 | Barcelona / El Prat (BCN/LEBL) | Brussels / Brussels (BRU/EBBR) | 06:31:00 | 08:17:00 | 01:46:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DLW |  | 0 | 0 | 3 |  | 239 | 403 | 668 | 231
2021-12-08 00:00:00 | FR2917 | Brussels / Brussels (BRU/EBBR) | Barcelona / El Prat (BCN/LEBL) | 09:06:00 | 11:06:00 | 02:00:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DLW |  | 0 | 0 | 3 |  | 403 | 239 | 668 | 231
2021-12-08 00:00:00 | FR3043 | Barcelona / El Prat (BCN/LEBL) | Venice / [NAME] (VCE/LIPZ) | 12:17:00 | 13:33:00 | 01:16:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DLW |  | 0 | 0 | 3 |  | 239 | 3148 | 668 | 231
2021-12-08 00:00:00 | FR3044 | Venice / [NAME] (VCE/LIPZ) | Barcelona / El Prat (BCN/LEBL) | 14:24:00 | 16:05:00 | 01:41:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DLW |  | 0 | 0 | 3 |  | 3148 | 239 | 668 | 231
2021-12-09 00:00:00 | FR6353 | Barcelona / El Prat (BCN/LEBL) | Bergamo / Orio Al Serio (BGY/LIME) | 06:40:00 | 08:01:00 | 01:21:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DPJ |  | 0 | 0 | 3 |  | 239 | 293 | 668 | 231
2021-12-09 00:00:00 | FR6354 | Bergamo / Orio Al Serio (BGY/LIME) | Barcelona / El Prat (BCN/LEBL) | 08:55:00 | 10:09:00 | 01:14:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DPJ |  | 0 | 0 | 3 |  | 293 | 239 | 668 | 231
2021-12-09 00:00:00 | FR3043 | Barcelona / El Prat (BCN/LEBL) | Venice / [NAME] (VCE/LIPZ) | 11:16:00 | 12:47:00 | 01:31:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DPJ |  | 0 | 0 | 3 |  | 239 | 3148 | 668 | 231
2021-12-09 00:00:00 | FR3044 | Venice / [NAME] (VCE/LIPZ) | Barcelona / El Prat (BCN/LEBL) | 13:46:00 | 15:11:00 | 01:25:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-DPJ |  | 0 | 0 | 3 |  | 3148 | 239 | 668 | 231
2021-12-11 00:00:00 | FR2918 | Barcelona / El Prat (BCN/LEBL) | Brussels / Brussels (BRU/EBBR) | 06:44:00 | 08:51:00 | 02:07:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-EMP |  | 0 | 0 | 3 |  | 239 | 403 | 668 | 231
2021-12-11 00:00:00 | FR2917 | Brussels / Brussels (BRU/EBBR) | Barcelona / El Prat (BCN/LEBL) | 09:15:00 | 10:58:00 | 01:43:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) | EI-EMP |  | 0 | 0 | 3 |  | 403 | 239 | 668 | 231
2021-12-15 00:00:00 | FR7513 | Barcelona / El Prat (BCN/LEBL) | Bristol / Bristol (BRS/EGGD) | 15:55:00 | 17:00:00 | 02:05:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) |  |  | 0 | 0 | 3 |  | 239 | 402 | 668 | 231
2021-12-15 00:00:00 | FR7514 | Bristol / Bristol (BRS/EGGD) | Barcelona / El Prat (BCN/LEBL) | 17:25:00 | 20:30:00 | 02:05:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) |  |  | 0 | 0 | 3 |  | 402 | 239 | 668 | 231
2021-12-16 00:00:00 | FR6305 | Barcelona / El Prat (BCN/LEBL) | Bergamo / Orio Al Serio (BGY/LIME) | 13:45:00 | 15:30:00 | 01:45:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) |  |  | 0 | 0 | 3 |  | 239 | 293 | 668 | 231
2021-12-16 00:00:00 | FR6304 | Bergamo / Orio Al Serio (BGY/LIME) | Barcelona / El Prat (BCN/LEBL) | 15:55:00 | 17:30:00 | 01:35:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) |  |  | 0 | 0 | 3 |  | 293 | 239 | 668 | 231
2021-12-16 00:00:00 | FR9815 | Barcelona / El Prat (BCN/LEBL) | London / Stansted (STN/EGSS) | 18:05:00 | 19:40:00 | 02:35:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) |  |  | 0 | 0 | 3 |  | 239 | 2785 | 668 | 231
2021-12-16 00:00:00 | FR9814 | London / Stansted (STN/EGSS) | Barcelona / El Prat (BCN/LEBL) | 20:10:00 | 23:20:00 | 02:10:00 | Ryanair (FR/RYR) | Boeing 737-800 (B738) |  |  | 0 | 0 | 3 |  | 2785 | 239 | 668 | 231