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!
Bookmarks