I need help writing the code for the SUMS columns to the right in the attached spreadsheet -- so that when I add hours in for any employee under the days of the week columns, it automatically updates their standard and overtime at the end of the week.
NOTE: If an employee works 8 ST hours on Monday and 4 OT hours on Monday, they will only get paid for 12 ST hours for the week since they didn't reach over 40.
What I'm looking for is to put code in cells R3 to S9, R12 to S18, and R21 to S27 that will take into account all the hours in the week and determine which ones are standard time and which ones are overtime hours. It's possible that an employee can only work 8 hours at one jobsite and those 8 hours be all overtime hours (if those 8 hours were on the last day of the week and they've already reached 40 hours in summation at other jobsites earlier on in the week.
I'm here to answer any questions.
Bookmarks