Labor Allocations surrounding OverTime

Hi all,

I know there are many questions asking for help dealing with payroll / overtime / etc. I have read them all and they do not apply to my situation. I am in charge of completing the labor allocations for events held at my workplace. I have created a spreadsheet to keep track of these in and normally its a piece of cake since events are a one day occurrence. Last week we had our state fair which ran for 10 days. Seven of those days were in one payroll period and the last three days were in another payroll period.

I created formulas to track the hours and regular pay. Then I added in a column to track the cumulative hours for each employee so that I would know when they reached overtime. When I created the formula for the overtime pay I wrote a formula to have it check the value in the cumulative column, see if it was over 40, and if so take the difference between 40 and the total to find the overtime and multiply it by the O/T rate.

Went one step further and had that formula subtract out the previous days overtime rates so that it reflects only the current days wages. HOWEVER, there lies my problem. I can't figure out how to write a formula that will prevent it from putting wages in the regular pay column if all the hours worked that day are overtime hours.

Help!?!