I have a mock file I created for our shop that I was hoping you could help me out with a key formula. I would like the formula to be written in the row highlighted yellow with a comment box I have wrote in the Payroll tab. What I want the formula to do is to take the total hours reported for the day, whereas they clocked in, and clocked out for lunch, and than clocked back in, and than clocked out for the day. On Monday, this is 10 hours. I want the 10 hours guaged against the tab that is called Time Sheet. This tab goes into the detail of the day, it should add up to what they are reporting on the Payroll tab to be paid. I just want some form of formula written that gives our clerical person an "error message" of some sort so they can pass the file back to the supervisor and tell them they cannot be paid for the hours until they update what the hours were assigned to.