I know this is a common issue, I looked around for how to fix but I am still having issues with Index and match using time to look up a value.

19:40:00 19:40 2
20:00:00 20:00 1
20:20:00 20:20 0
20:40:00 20:40 2
21:00:00 21:00 0
21:20:00 21:20 3
21:40:00 21:40 0
20:00:00 20:00
20:00:00 #N/A

The #N/A is =INDEX(C1:C7,MATCH(B8,A1:A7,0))
A column is normal time format
B is =TEXT(A1,"HH:MM")

Any way I cam reformat this for index match to read the time and get a match.