Flight Time Extraction for 24 hrs, Weekday, and Month blocks

flydude

New Member
Joined
Dec 8, 2014
Messages
2
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.


Leg Depart DateLeg Depart TimeArrival DateArrival Time00:00 - 01:0001:00 - 02:0002:00 - 03:0003:00 - 04:0004:00 - 05:0005:00 - 06:0006:00 - 07:0007:00 - 08:0008:00 - 09:0009:00 - 10:0010:00 - 11:0011:00 - 12:0012:00 - 13:0013:00 - 14:0014:00 - 15:0015:00 - 16:0016:00 - 17:0017:00 - 18:0018:00 - 19:0019:00 - 20:0020:00 - 21:0021:00 - 22:0022:00 - 23:0023:00 - 24:00 MonTueWedThuFriSatSun JanFebMarAprMayJunJulAugSepOctNovDec
Jan 7, 200512:54:00 AMJan 7, 20053:00:00 AM
Apr 28, 20052:23:00 AMApr 28, 20054:20:00 AM
Jun 30, 20051:55:00 AMJun 30, 20053: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.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
3,099
Office Version
  1. 365
Platform
  1. Windows
If you create pivot tables with your data you can group different time periods to display the info in the ways you're describing.
Create a pivot table, put the date in the row area and your departure and arrival times in the columns area. Then right click on the dates info and click group to bring up the different grouping options.
 

flydude

New Member
Joined
Dec 8, 2014
Messages
2
Thanks for the response, but i don't know if that's exactly what I'm looking for. I will give it a try but was looking for a formula of some sort that would look at the depart and arrival times and give me the exact minutes that were flown for that hour block. ..also some type of formula would take into count the depart date, along with the depart/arrival times and give me total minutes or hours flown during monday. ..and the again for all the months. Ultimately I would like to record a macro to apply this to multiple sheets. I will try method just to make sure it is not what I want though. Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,127,653
Messages
5,626,101
Members
416,161
Latest member
David1966Lewis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top