Hi,

Am Mon, 24 Nov 2014 17:51:20 +0000 schrieb kiktuo:

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.

is a date in another column?
Please post an example of your data and show us your expected result.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional