Thank you. I used the below formula but not returning a value. (see attached document) =IF(MINIFS($C$2:$C$14,$B$2:$B$14,B2)=C2,C2,""). If I wanted to add a 1 in column E for the min time for that date, is it possible. Thank you again for your help.

Attached Files

min time on date.xlsx (9.3 KB, 11 views)