aliaslamy2k
Active Member
- Joined
- Sep 15, 2009
- Messages
- 416
- Office Version
- 2019
- Platform
- Windows
Dear Experts,
I am working on a project where i want to know if we can connect passengers within 45 min ( in a seperate cell to change the minutes as require) from schedule time of arrival (STA) and actual time of arrival ( ATA ) and connecting to another train with schedule time of departure (STD ) and actual time of departure keeping in mind of date change as well.
i.e : Arrival is 10 Jan 2015 23:59 and departure on 11 June 00:15.
<colgroup><col><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I am working on a project where i want to know if we can connect passengers within 45 min ( in a seperate cell to change the minutes as require) from schedule time of arrival (STA) and actual time of arrival ( ATA ) and connecting to another train with schedule time of departure (STD ) and actual time of departure keeping in mind of date change as well.
i.e : Arrival is 10 Jan 2015 23:59 and departure on 11 June 00:15.
A | B | C | D | E | F | G | H | I | J | K | L | M |
Inbound | in date | In Sector | Schedule time of Arrival (STA) | Actual Time of Arrival (ATA) | OutBound | Out Date | Out Sector | Schedule time of Departure (STD) | Actual Time of Arrival (ATD) | Result with STA | Result with STD | Total passengers |
Train1 | 10-Jan-15 | AAA | 23:50 | 0:15 | Train4 | 11-Jan-15 | EEE | 00:55 | 00:57 | 8 | ||
Train2 | 11-Jan-15 | BBB | 0:10 | 0:45 | Train5 | 11-Jan-15 | FFF | 00:55 | 01:03 | 10 | ||
Train3 | 11-Jan-15 | CCC | 5:00 | 0:59 | Train6 | 11-Jan-15 | GGG | 05:45 | 05:45 | 1 | ||
Train4 | 1-Jan-15 | DDD | 6:15 | 06:31 | Train7 | 1-Jan-15 | HHH | 07:00 | 07:11 | 20 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>