The solution for gate management

[airlinemanage]

Just noticed a small error, column I is the ready time not the arrival time of an aircraft. The difference is ready time is the time after an aircraft completes the turnaround step. So, in order to get the arrival time, you should type in the turnaround time in column H. Modify I2 formula to:
=IF(ISNUMBER(SEARCH("— PEK",$A2)),$D2-$H2,IF(AND(ISNUMBER(SEARCH("PEK —",$A2)),$F2<>$F1),2/24,""))


and apply the formula to the whole column, then you'll notice that column I has the arrival time.