Forum Discussion

squirrell's avatar
squirrell
Copper Contributor
Jun 19, 2019

Excel Formula Help - Timesheets

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!

Resources