Hi Everyone! Penalty Rates question right off the bat!

Hi All

I've just joined the Excel Forum. I'm an accountant so I'm fairly involved with using Excel day to day, however I know there is so much I don't even realize Excel can do. I'm hear to learn more. And I've got a problem already...

I'm trying to help a small business get their wages in order and I need a formula to show that if working from 17:00-21:00 on Thursday nights, their pay goes to 1.5*normal rate. Does this make sense? I've attached the draft of the worksheet I've filled out.

Thanks!