Thanks Mazzaropi this worked :-). I really appreciate the assistance. I now need to add an additional field to the formula. Where the agent is entitled to a 1 hour/30 min break based on their shift. i.e 6hour shift gets 30min break, both other shifts get 1hour break. should they exceed their break by more than 3minutes then the result should be a no, regardless if their shift times are within the predefined criteria.

Regards,
SalientAnimal