VLOOKUP a date+time with only a date

[rgsanchez]

Can I Vlookup a date+time if I only have the time? For example, I have the Scheduled Time only in Table B. I want to Vlookup the Date+Time from Table A.

Table A: Reference Table			Table B: Final Table
Scheduled Date+Time	Actual+Time		Scheduled Time	Actual Date+Time (VLOOKUP)
8/1/2019 4:00	8/1/2019 4:00		4:00
8/1/2019 4:06	8/1/2019 4:06		4:06
8/1/2019 4:07	8/1/2019 4:08		4:07

<tbody>
</tbody>

 

[Sam_D_Ben]

I am not sure if this work for you. Please check.

Excel 2013/2016
	A	B	C	D	E
1	Scheduled Date+Time	Extr-Time	Actual+Time	Scheduled Time	Actual Date+Time (VLOOKUP)
2	8/1/19 4:00	04:00	8/1/19 4:00	4:00	8/1/19 4:00
3	8/1/19 4:06	04:06	8/1/19 4:06	4:06	8/1/19 4:06
4	8/1/19 4:07	04:07	8/1/19 4:08	4:07	8/1/19 4:07
Sheet1

Cell Formulas
Range	Formula
B2	=TEXT($A2-INT($A2),"HH:MM")
E2	=INDEX($A2:$A4,MATCH(TEXT($D2-INT($D2),"HH:MM"),$B2:$B4))