dieselkhan
New member
- Joined
- Sep 6, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I need to calculate how many pairings can operate to contractual and regulatory requirements.
CAP rules are, a Pilot can be on duty at 0600 Local and be off duty by 2359 Local
Contract rules are, a Pilot can be on at 0800 Local and be off duty by 2100 Local.
A pilot is on duty 01:15 prior departure time off flight
A pilot is off duty 00:30 after arrival time off flight.
I need to break down the report as I only need departures out of Base, BHX|LTN|LGW|EMA|LBA|MAN and arrivals into the same baseView attachment Book1.xlsx
CAP rules are, a Pilot can be on duty at 0600 Local and be off duty by 2359 Local
Contract rules are, a Pilot can be on at 0800 Local and be off duty by 2100 Local.
A pilot is on duty 01:15 prior departure time off flight
A pilot is off duty 00:30 after arrival time off flight.
I need to break down the report as I only need departures out of Base, BHX|LTN|LGW|EMA|LBA|MAN and arrivals into the same baseView attachment Book1.xlsx