I am trying to make a timesheet that calculates overtime with the following criteria...
1. Overtime is after 8hrs on any given day.
2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime.
3. The after 40hrs/week overtime criteria changes if there is a Stat holiday...if there is one stat holiday in the week overtime is calculatd after 32hrs/week,
1. Overtime is after 8hrs on any given day.
2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime.
3. The after 40hrs/week overtime criteria changes if there is a Stat holiday...if there is one stat holiday in the week overtime is calculatd after 32hrs/week,
if there is two stat holiday in the week overtime is calculatd after 24hrs/week etc. Basically for every stat holiday during the week the overtime threshhold changes by 8hrs.
Spreadsheet is set-up with days of the week across the columns, employee names down the rows.
Daily total hours for each employee are entered in the appropriate cells and the formulas need to do all the overtime calculations.
I was planning on using text "Stat" in the cells were a stat holiday occured.
I have managed to calculate all the criteria except the "Stat" holiday criteria without circular references but I am now stumped and have not found a solution on any posts.
Spreadsheet is set-up with days of the week across the columns, employee names down the rows.
Daily total hours for each employee are entered in the appropriate cells and the formulas need to do all the overtime calculations.
I was planning on using text "Stat" in the cells were a stat holiday occured.
I have managed to calculate all the criteria except the "Stat" holiday criteria without circular references but I am now stumped and have not found a solution on any posts.