Matching date and time

[hanif]

Hi All,

I have attached a sheet, as you can see column A and F have some dates, Column B time which increase every 15 min and Column G with time increases every 10 min. Column C has values of 1 and 0. I am looking for a fuction to look if dates (Col A and F) are matched and if time in col G are equal or included in time in Col B then the value in Col C be in Col H. I have shown my expectation in red in the attached. Thanks for your help.