Can anyone tell me if it is possible to use a formula to calculate overtime (w/ overtime being anything over 40 minus holidays, vacations, etc…)?
I found a formula that works as long as there is overtime to report, otherwise, I get the “#####” error. If possible I would like the cell to show “0” rather than the error message if there is no overtime. I have tried using the IF function but I am either using it wrong or I am not understanding the IF function right.
