VLOOKUP for Times, Not Matching based on rounding?

[ARW17]

I'm having a problem getting a VLOOKUP to work where Excel thinks the times 3:45 PM and 3:45 PM don't match. Both are formatted H:MM AM/PM.

When I evaluate the formula it shows that one is 0.65625 and the other is 0.65624999999999.

The one it marks as 0.65625 is generated from the formula:

{=IF(VLOOKUP(B80,'S-S Staffing'!A:G,7,FALSE)<>"",VLOOKUP(B80,'S-S Staffing'!A:G,7,FALSE),IF(ISNA(INDEX('Daily Setup'!$E$17:$E$158,MATCH($B80&$E$1,'Daily Setup'!$D$17:$D$158&'Daily Setup'!$E$17:$E$158,0),MATCH(I$2,Staffing!$D$2:$J$2,0))),INDEX(Staffing!$N$2:$T$245,MATCH($D$1&$B80,Staffing!$A$2:$A$245&Staffing!$M$2:$M$245,0),MATCH(I$2,Staffing!$D$2:$J$2,0)),INDEX('Daily Setup'!$F$17:$F$158,MATCH($B80&$E$1,'Daily Setup'!$D$17:$D$158&'Daily Setup'!$E$17:$E$158,0))))}

The one it marks as 0.65624999999999 is just text: 3:45:00 PM.

How can I fix this?

 

[Losnalgas]

Hello, have you tried using the =Round() function? so =vlookup(round(x,6),z:az...and so on. that assumes the array function is always pulling to the sixth decimal point