Any idea how I go about calculating wages that are based on time rates as per example below.
I'm just not sure how to automatically work it out if the hours go through different pay rates as in D7 through F9
RATE 1 = 9AM - 8PM MON-FRI
RATE 2 = 8PM - 9AM MON-THUR
RATE 3 = FRI 8PM - MON...