Formula, Excel, Different daily rate, Weekend, Weekday

Hi everyone,

Based on the table below, I would like to get a formula to be able to invoice the correct rate.

Rate Business days Business hours
100% Monday to Friday (day) 6am to 8pm
125% Monday to Friday (night) 8pm to 6am
150% Saturday (day) 6am to 8pm
175% Saturday (night) 8pm to 6am
220% Sunday (day) 6am to 8pm
245% Sunday (night) 8pm to 6am
250% Bank Holiday 6am to 8pm

Any help will be highly appreciated.