Hi, I want to have a validation on a time sheet that if the lunch time is not entered then the daily total will not calculate.
The lunch time is entered in cell D15, the daily total is in cell D16. I need an IF validation that states if D15 is 0 then D16 will not total and be 0. D16 currently has a formula to add the times from the entire day together.
Just can't figure this one out, any ideas? Thank you