I am working on a work schedule and have come across a problem. I want to be able to add a condition to a formula that "If an empoyee works 6 or more hours in one day, then 1/2 an hour (00:30) will automatically be subtracted from the total for that day. (On the other hand, and it may be easier said this way) if the employee works less than 6 hours, I don't want the 1/2 hour to be taken out. I am currently using the formula =(B1-A1) where B1 is the "Ending Time" and A1 is the "Starting Time" --- The problem is that an employee doesn't work over 6 hours every day, and therefore doen't take a lunch period. The schedule may change from week to week or day to day. I appreciate any help!