Convert text to time and vlookup getting error.

Hi, I'm working with some data and need a help to convert a text to time then use the time to vlookup on another sheet.

I'm attaching a sample file to explain where I have issues.

the gray columns are the data I receive to work,the M and O columns are the text that I converted to time in the columns R and X.

I need to use the converted data to vlookup that time in the sheet1, but I'm getting #N/A or inaccurate lookup values.

What can I do to solve this problem?

Thanks in advance and sorry about my bad english