Hi All!
I appreciate anyone that even just reads this and wants to give me advise on where to go if this is too much to ask.
Each row is a day.
Rule 1. The first 10 hrs at x1 pay.
Rule 2. After 10 hrs is x1.5 pay (up to 16hrs)
Rule 3. After 16 hrs is x2 pay
Rule 4. After 40 hrs is x1.5
Formulas in are greatly appreciatedAG:AH
The gray area are the results that I need from the white grid and are shown as an example.
Here's the rules:
The formula can start in the 2nd row down. The first row will just be = as 40 hrs can't be exceeded in 1 day. (A few times I felt like it came close)
Rows in AG are never >10
The sum of AG is never >40
I'll try to explain the desired results in the gray area.
AD61 sums X60:Z61 (1st 2 days) and if it's <40 then 10. (>40 explained below)
AE61 sums X60:Z61 and if it's <40 then Y61.
(Day 2 did not work past 40hrs so 10hrs of x1 and didn't work more than 10 hrs so no x1.5)
AD62 sums X60:Z62 (1st 3 days =38hrs so far) Same rules but worked 18hrs. AE62= Rule 2.
The x2 column is only used for hrs worked and is not need for anything else here.
(Day 3 did not work past 40hrs but exceeded Rule 2&3
AD63 is where the fun begins.
AD63 sums the first 4 days = 52 hrs. (Sum X60:Z63>40)
AD63 is only allowing 2 hrs as not to exceed a 40hr week.
AE63 calculates the remainder of the hrs.
AD64 can no longer show any hrs per Rule4.
After AE calculates a remainder from AD, the rest of AE sums x1 and x1.5 rows.
(Day 4 exceeded 40 hrs. The 2nd hr reached the 40hr ot rule so 2 hrs of x1 and the remaining 8hrs get added to the 4 hrs of x1.5)
I send this off with hesitation as I'm not sure if I explained this well and get people annoyed.
I'm embarrassed to say how long I have been trying to sole this.
Thank you in advance
I appreciate anyone that even just reads this and wants to give me advise on where to go if this is too much to ask.
Each row is a day.
Rule 1. The first 10 hrs at x1 pay.
Rule 2. After 10 hrs is x1.5 pay (up to 16hrs)
Rule 3. After 16 hrs is x2 pay
Rule 4. After 40 hrs is x1.5
Formulas in are greatly appreciatedAG:AH
The gray area are the results that I need from the white grid and are shown as an example.
Here's the rules:
The formula can start in the 2nd row down. The first row will just be = as 40 hrs can't be exceeded in 1 day. (A few times I felt like it came close)
Rows in AG are never >10
The sum of AG is never >40
I'll try to explain the desired results in the gray area.
AD61 sums X60:Z61 (1st 2 days) and if it's <40 then 10. (>40 explained below)
AE61 sums X60:Z61 and if it's <40 then Y61.
(Day 2 did not work past 40hrs so 10hrs of x1 and didn't work more than 10 hrs so no x1.5)
AD62 sums X60:Z62 (1st 3 days =38hrs so far) Same rules but worked 18hrs. AE62= Rule 2.
The x2 column is only used for hrs worked and is not need for anything else here.
(Day 3 did not work past 40hrs but exceeded Rule 2&3
AD63 is where the fun begins.
AD63 sums the first 4 days = 52 hrs. (Sum X60:Z63>40)
AD63 is only allowing 2 hrs as not to exceed a 40hr week.
AE63 calculates the remainder of the hrs.
AD64 can no longer show any hrs per Rule4.
After AE calculates a remainder from AD, the rest of AE sums x1 and x1.5 rows.
(Day 4 exceeded 40 hrs. The 2nd hr reached the 40hr ot rule so 2 hrs of x1 and the remaining 8hrs get added to the 4 hrs of x1.5)
I send this off with hesitation as I'm not sure if I explained this well and get people annoyed.
I'm embarrassed to say how long I have been trying to sole this.
Thank you in advance
