Good day,
I am struggling to enter a formula into Excel.
We do our employees time sheets on Excel. I am trying to automate the calculation of the absent days, off days and overtime due.
I have gotten the formula correct for the absent days, off days and overtime.
There is just one issue that I can not resolve.
We don't want the employees to get penalized on their overtime if they have any absent or off days. I can not get the formula to calculate it correctly.
I want to enter the following formula into AJ4:
=(SUM(D4:AG4))+(AH4*8.5)+(AI4*8.5)
note: the 8.5 is the normal working hours per day
If I type in the above formula the answer is completely wrong.
Please can someone help me.
Thank you in advance!
Did you like this article? Share it with your favourite social network.