Creating Connecting Network Units (airports)

[Excelnoob123]

Hi,

I am trying to create something called network units.

To do that I have two separate airport schedules. One for all landings, and one for all departures. I have been trying to figure out how to write a code to identify to generate the possible combinations within a 2 to 6 hour connection. I would be grateful for help if anyone knows how to write such a code. A snapshot of the data is provided below.

If there is data on the left side of hub timing, it means an arriving flight.
If there is data on the left side of hub timing, it means a departing flight.

Equip	Op Days	Mkt Al	Flight	Stops	Orig	Dep Time	Hub timing	Arr Time	Dest	Stops	Mkt Al	Flight	Op Days	Equip	Seats	Ops/Week
789	1234567	EY	487	0	PER	1705	0035									7
32B	1234567	TK	868	0	IST	1915	0055									7
388	1234567	EY	20	0	LHR	1405	0120									7
							0150	0615	IST	0	TK	869	1234567	32B	178	7
							0205	0645	DUB	0	EY	45	123456.	77W	412	6
							0205	0645	DUB	0	EY	45	......7	77W	380	1
							0210	0625	LHR	0	BA	72	1234567	789	216	7

 

[mitsuirows]

OP, did you end up figuring this out? I'm having some trouble deciphering some of these columns. Why are their duplicate columns? What is hub timing supposed to be here?