I'm trying to figure out ho to figure out when overtime hours start.
A couple of rules: First of all, overtime is paid after 40 hours. There is a 1st shift, a 2nd shift, and a 3rd shift.
Then imagine that an employee worked 8 hours on Monday on the 1st shift, 8 hours on Tuesday on the 1st shift, 8 hours on Wednesday on the 1st shift. Then on Thursday he worked 8 hours on the 2nd shift. Then on Friday he worked 16 hours on the 3rd shift. So he worked a total of 48 hours. I have to show the data like this and can't figure out how to do it. I can easily show the data in the columns named "1st Shift", "2nd Shift", "3rd Shift", and "Total Hours" but I cannot figure out how to get the data in the columns named "1st Shift OT", "2nd Shift OT", and "3rd Shift OT".