I took a guess and with the understanding the times are in a different column than dates ...
In the attached I copied the bins into column F, removed duplicates.
Then in G2 array entered this formula filled down and across.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Formula:
=INDEX(B$2:B$16,MATCH(MIN(IF($F2=$A$2:$A$16,$B$2:$B$16+$C$2:$C$16)),($F2=$A$2:$A$16)*($B$2:$B$16+$C$2:$C$16),0))
and reformatted for date / time / General
Bookmarks