Excel formula not working for overtime calculation

[Helizelb]

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!