Hi all,

Attached is my spreadhseet i am using to schedule arrivals/departures.

In cell J3 i am look for a formaul to find the earlier time in column F, these time occure both before and after midnight ie. 19:30 is earlier than 01:00 in terms of a arrivals for a night shift.

Any help would be much appreciated.

Thanks
Kiktuo

Timings Example.xlsx