Jun 19 2019 07:36 PM
I have created a timesheet and I want to have a note appear if the employee has not entered the correct times for their breaks.
So I think an IF formula would be best but it's not saying the correct response. I have a formula to work out how long the break has been from the times entered. I want to say IF the answer in that formula is not equal to 0.33 then return a Check your break. But everytime I do this it fails in the execution. I've attached my sheet to show. I've tried an AND function as well.
Help!
Jun 20 2019 02:41 AM