A B C D E F G H
Name Start End hours worked Straight Shift Diff OT Shift Diff OT
MR A 02/25/2018 06:10 02/25/2018 18:40 12 0.7 0 0
MR A 02/27/2018 06:10 02/27/2018 18:40 12 0.7 0 0
MR A 03/02/2018 06:10 03/02/2018 18:40 12 0.7 0 0
MR A 03/03/2018 06:10 03/03/2018 18:40 12 0.7 0 0
48 40 2.8 0 0
OK, having issues with formula or trying to figure out how to automate with formulas, the table above is what i have working so far. I've been working on this for a week and cant figure out formulas that need to use. Thank you in advance.
- E5 needs to change to automatically not go over 40 hrs and the remainder need to go into G5
ex. if 12 is imputed in E5 it should auto change to 4 and put the remaining 8 to G5 as OT
- when OT is incurred as in E5 the shift diff in F5 needs to be placed into H5 instead to be payed as Shift Diff OT
- shift diff will be imputed manually in F2-F5
This is what I need it too look like after all formulas are imputed to auto populate as I input the info.
A B C D E F G H
Name Start End hours worked Straight Shift Diff OT Shift Diff OT
MR A 02/25/2018 06:10 02/25/2018 18:40 12 0.7 0 0
MR A 02/27/2018 06:10 02/27/2018 18:40 12 0.7 0 0
MR A 03/02/2018 06:10 03/02/2018 18:40 12 0.7 0 0
MR A 03/03/2018 06:10 03/03/2018 18:40 4 0.0 8 .7
48 40 2.1 8 .7
Name Start End hours worked Straight Shift Diff OT Shift Diff OT
MR A 02/25/2018 06:10 02/25/2018 18:40 12 0.7 0 0
MR A 02/27/2018 06:10 02/27/2018 18:40 12 0.7 0 0
MR A 03/02/2018 06:10 03/02/2018 18:40 12 0.7 0 0
MR A 03/03/2018 06:10 03/03/2018 18:40 12 0.7 0 0
48 40 2.8 0 0
OK, having issues with formula or trying to figure out how to automate with formulas, the table above is what i have working so far. I've been working on this for a week and cant figure out formulas that need to use. Thank you in advance.
- E5 needs to change to automatically not go over 40 hrs and the remainder need to go into G5
ex. if 12 is imputed in E5 it should auto change to 4 and put the remaining 8 to G5 as OT
- when OT is incurred as in E5 the shift diff in F5 needs to be placed into H5 instead to be payed as Shift Diff OT
- shift diff will be imputed manually in F2-F5
This is what I need it too look like after all formulas are imputed to auto populate as I input the info.
A B C D E F G H
Name Start End hours worked Straight Shift Diff OT Shift Diff OT
MR A 02/25/2018 06:10 02/25/2018 18:40 12 0.7 0 0
MR A 02/27/2018 06:10 02/27/2018 18:40 12 0.7 0 0
MR A 03/02/2018 06:10 03/02/2018 18:40 12 0.7 0 0
MR A 03/03/2018 06:10 03/03/2018 18:40 4 0.0 8 .7
48 40 2.1 8 .7