'Calculating percentages for the month and working time

In the previous Article, I asked you for help in calculating the percentages in a given range, now I need further help

Link to the previous article how to find the percentage between 2 numbers with 2 conditions?

Now I need to calculate the bonus to the employee it consists in the fact that the employee has a bonus paid for each day where the bonus has been earned, but I must have a result in one cell

https://docs.google.com/spreadsheets/d/1xtf9ZUecahZTnB6dNKQAKMO7e1qTmv6qbNHsQ0wWpI0/edit#gid=51882774

Table preview

C17 - Name

C18 - hourly rate

D18,F18,H18,J18,L18,N18,P18,R18,T18,V18 - It has a formula =IFS(D17<90%;0;D17>120%;15%;PRAWDA;D17*37,5%-30%)

E18,G18,I18,K18,M18,O18,Q18,S18,U18,W18 - It has a formula =$C18*D18*(E17*24)

Currently, after adding the amount for each day, cells E18,G18,I18,K18,M18,O18,Q18,S18,U18,W18 It is equal 58,08 zł

And if we add up all the norms from line 18 and divide them into the number of days, in this case there are 10 of them, we get 4,450125% where, after multiplying the working time "67:02:34" by the hourly rate and the percentage obtained earlier, we get the sum of 59.67 zł



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source