Please provide a bit of guidance and help. I came across a spreadsheet that has some formulas to validate if an agent went over the allowed break or lunch time based on Staffed time. Could someone help me figure out how to add to the formula. Specifically in between the shift minutes.(i.e under 240 min comes back as 0) i.e(a cell that has between 241 and 299)

My spreadheet contains the staffed time in seconds, break and lunchtime in seconds. I need to figure out if based on the staffed time they went over the allotted amount of time allowed and the % they went over. I attached a spreadsheet for viewing. C12-staffed time/ D12 Lunch time/ I12 contains formula. The Tables for Breaks, lunch and preshift are on top. Im an Excel newbie, so any help would be appreciated....

Thank you for your help!!!!! This place Rocks!!!!!

## Bookmarks