[h=2]Flight Time Extraction for 24 hrs, Weekday, and Month blocks[/h]
I am trying to extract the flight time from a leg depart date, leg depart time, arrival date, and arrival time.
First I would like to gather all minutes of flight time flown from 00:00-01:00 and so on.
Second, I would like to gather all of the flight time flown on Mondays and so on.
Third, I would like to gather all flight time flown in January and so on. The below is a snapshot of my data, but I would like to email the snapshot of the actual spreadsheet if someone can help.
Ex. Based off of the the first flight below (jan 7).. the flight time for the hour block would be around 6 mins for 1200-1300, 60 mins for 1300-1400, etc
3 hrs and 6 mins for sat (probably use the weekday function, and 3 hrs and 6 min for Jan.
I am trying to extract the flight time from a leg depart date, leg depart time, arrival date, and arrival time.
First I would like to gather all minutes of flight time flown from 00:00-01:00 and so on.
Second, I would like to gather all of the flight time flown on Mondays and so on.
Third, I would like to gather all flight time flown in January and so on. The below is a snapshot of my data, but I would like to email the snapshot of the actual spreadsheet if someone can help.
Ex. Based off of the the first flight below (jan 7).. the flight time for the hour block would be around 6 mins for 1200-1300, 60 mins for 1300-1400, etc
3 hrs and 6 mins for sat (probably use the weekday function, and 3 hrs and 6 min for Jan.