Earliest and Lastest Value based on Matrix Row

[NSMEED]

Hello-

Currently I have 2 matrixs, arrivals by company showing earliest time and departures by company showing latestest time. I would like to have one matrix with arrival/departure in the rows and need help writing the formula if arrival then earliest time else latest time.

Basically want to reduce this to one column that will take the first or last flight time based on arrival/departure.

Thanks

[parry2k]

@NSMEED what is the condition, is not clear.

if arrival then earliest time else latest time.

[NSMEED]

On the top with arrivals I want the earliest parse but on the bottom with departures I want lastest parse contained to 1 column in the picture above.

Sorry first post so will try and be clearer!