Hello,
I am having a little, okay, a lot, of trouble figuring out how to calculate time ad a half when it comes to wages.

Straight time is up to 8 hours
Time and a half between 8 and 12 hours
Double time - any hours after 12

Cell G2 is the issue. It ends up showing me all hours after 8, but what I really want is hours between 8 and 12.

B2 - In
C2 - out
D2 - In
E2 - Out
F2 - Regular time =IF((((C2-B2)+(E2-D2))*24)8,8,((C2-B2)+(E2-D2))*24)
G2 - Time and a half = =IF(((C2-B2)+(E2-D2))*248,((C2-B2)+(E2-D2))*24-8,0)
H2 - Double time =IF(((C2-B2)+(E2-D2))*2412,((C2-B2)+(E2-D2))*24-12,0)

Any help would be really appreciated. I hope it doesn't sound too confusing.

Thank-you