Hello, hope someone can help me out.
This is my problem: I want to use the date in the fourth row to look for the earliest time in the 2nd row given the date.
I can't seem to work it out, I've tried a variety if min-if formulas and index min match.
Thanks!

date time start time end date start time
12/1/16 8am 930am 12/1/16
12/1/16 930am 2pm 12/2/16
12/1/16 2:30pm 5pm 12/3/16
12/2/16 8am 11am
12/2/16 12pm 4pm
12/3/16 7am 2pm
12/3/16 2pm 3pm
12/3/16 3pm 5pm