Hi all,

I am using to schedule arrivals/departures.

In cell J3 i am look for a formula to find the earlier time in column F, these times in column F occure both before and after midnight ie. 19:30 is earlier than 01:00 in terms of a arrivals for a night shift. I need a formula to find the earliest time in the list taking this into account, min does not work as it sees 00:30 as earlier than 21:30 for example.

Any help would be much appreciated.

Thanks
Kiktuo