Well, the range is from 0:00:00 to 23:59:00 which is virtually a complete day, so I presumed the OP wanted to check for times which wrap around midnight, based on the formula in column G, and the range becomes irrelevant.

Pete