I am trying to extract the flight time from a depart date, 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.
<colgroup><col span="2"><col span="2"><col span="24"><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"><col><col><col><col span="2"><col span="2"><col span="24"><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col></colgroup><tbody></tbody>
Ultimately, I am trying to get total minutes flown in these different strata so that I can get mishap rates per strata.
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.
Leg Depart Date | Leg Depart Time | Arrival Date | Arrival Time | 00:00 - 01:00 | 01:00 - 02:00 | 02:00 - 03:00 | 03:00 - 04:00 | 04:00 - 05:00 | 05:00 - 06:00 | 06:00 - 07:00 | 07:00 - 08:00 | 08:00 - 09:00 | 09:00 - 10:00 | 10:00 - 11:00 | 11:00 - 12:00 | 12:00 - 13:00 | 13:00 - 14:00 | 14:00 - 15:00 | 15:00 - 16:00 | 16:00 - 17:00 | 17:00 - 18:00 | 18:00 - 19:00 | 19:00 - 20:00 | 20:00 - 21:00 | 21:00 - 22:00 | 22:00 - 23:00 | 23:00 - 24:00 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Jan 7, 2005 | 12:54:00 AM | Jan 7, 2005 | 3:00:00 AM | |||||||||||||||||||||||||||||||||||||||||||||
Apr 28, 2005 | 2:23:00 AM | Apr 28, 2005 | 4:20:00 AM | |||||||||||||||||||||||||||||||||||||||||||||
Jun 30, 2005 | 1:55:00 AM | Jun 30, 2005 | 3:33:00 AM |
<colgroup><col span="2"><col span="2"><col span="24"><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"><col><col><col><col span="2"><col span="2"><col span="24"><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col></colgroup><tbody></tbody>
Ultimately, I am trying to get total minutes flown in these different strata so that I can get mishap rates per strata.