Excel cell value comparison

I have 2 excel sheets, one is master sheet and other one is date reference sheet.

master sheet has a column name time which it contains time format values (HH;mm) and it also has text values 8pm 8.15am etc.

date ref sheet has time format column with its respective hour and minutes result in it.

Example1: reading 8am in master, filter the same value in date ref, match found then i will take the relative column result as 8 as hour and 00 as minute.

Example2: reading 7:30 in master, filter the same value in date ref, match found then i will take the relative column result as 7 as hour and 30 as minute but here 7:30 will be read as 0.3125 value and it will be compared with date ref sheet because am not using any formatting values.

Main.xaml (23.9 KB)

master_sheet.xlsx (10.2 KB)
Time Reference Table.xlsx (13.4 KB)

My issue is, the double value compared in both sheets are same but at the time of execution the double value differs between excel sheets, so the filter data is not working as expected.

can anyone please help me to get a solution?

attached are the files used.