Hi Everyone,
I hope you all are well.
Am trying hard with an IF formulas trying to calculate hours of overtime for driver project.
This is the formula
1.jpg
(I tried to attach the file, but something it's wrong with the attachment option)
So the formula is: =IF(C4="Monday",(J1-D4)+(E4-K1),"") and it is calculating correct.
But when I want to add other conditions inside the formula the problems show up.
=IF(C4="Monday",(J1-D4)+(E4-K1),""),IF(C4="Saturday",(J2-D4)+(E4-K2),"")) : You've entered too many arguments for this functions.
Why does this happen? And how can I overcome this problem?
I am trying to calculate the regular hrs with to hrs based on the weekdays and holidays.
Kindly, I will appreciate a lot your help.
Regards,
Bookmarks