guilherme88
New Member
- Joined
- Aug 1, 2018
- Messages
- 16
Hi all,
I have been struggling with the following for a number of days now.
I want to be able to retrieve the flights that can be connected with Y flight.
Basically..
I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X" flights give enought time to connect with AA0001. I have tried index&sumproduct and index&match&countif but nothing seems to work.
Is anybody able to help me?
See below some data, which might be able to explain better what i mean..
The issue is that the data repeats itself depending on the day of the season which could be 10march, 03august, 02sep or any other date. I want to retrieve the possible connection options so for the case below, if i have a flight departing at 05:45 the flight AA100 would connect with. but if i have a flight leaving at 05:20 AA100 would not connect with it.
Please help
FLIGHT NR ARR/DEP ACTUAL TIME CONNECTION TIME DAYS OF WEEK SEASON
[TABLE="class: cms_table, width: 914"]
<tbody>[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD][/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD]Mon[/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD][/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD]Mon[/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD]Mon[/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
</tbody>[/TABLE]
I have been struggling with the following for a number of days now.
I want to be able to retrieve the flights that can be connected with Y flight.
Basically..
I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X" flights give enought time to connect with AA0001. I have tried index&sumproduct and index&match&countif but nothing seems to work.
Is anybody able to help me?
See below some data, which might be able to explain better what i mean..
The issue is that the data repeats itself depending on the day of the season which could be 10march, 03august, 02sep or any other date. I want to retrieve the possible connection options so for the case below, if i have a flight departing at 05:45 the flight AA100 would connect with. but if i have a flight leaving at 05:20 AA100 would not connect with it.
Please help
FLIGHT NR ARR/DEP ACTUAL TIME CONNECTION TIME DAYS OF WEEK SEASON
[TABLE="class: cms_table, width: 914"]
<tbody>[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD][/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]100[/TD]
[TD]Arrival[/TD]
[TD]04:55[/TD]
[TD]05:40[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD]Mon[/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD][/TD]
[TD]Tue[/TD]
[TD][/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD]Mon[/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]101[/TD]
[TD]Departure[/TD]
[TD]12:55[/TD]
[TD]12:10[/TD]
[TD]Mon[/TD]
[TD][/TD]
[TD]Wed[/TD]
[TD][/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]Sun[/TD]
[TD]Winter[/TD]
[/TR]
</tbody>[/TABLE]