OK - suggest using auto filters to identify those rows where the clock off time exceeds 6am on Monday and change these to 6am. Likewise for those starting before Saturday 8PM. The formula shold then give you the answer you need.