Day and time formula to return specific values based on a table(of some sort)

[TheAdvent420]

Good afternoon,

I hope we're all well.

I'm usually able to find what i'm looking for when it comes to excel and formulas but this one has me stumped.
I'm hoping that someone obviously smarter than I would be able to help!

So I'm formulating a sheet which returns rates based on a time range and a specific day.

An example of the rates would be:

And on the main sheet there will be 3 columns

Day
From
To

Based on the 3 columns and the values punched in would I be able to return the above rates?

Any help at all would be majorly appreciated, So thanks in advance!

Regards,

 

[TheAdvent420]

Update:

I found this on Chatgpt but it always returns a "0";

=INDEX(value_range, MATCH(1, (text_range=A1)*(start_time_range<=B1)*(end_time_range>=B1), 0))