Overlapping Time Based on Conditions

Looking at Tim's solution, he made much better use of column D than I did. I overlooked the fact that my helper column already existed; there really wasn't any need for me to create the extra column and table. My cleaner version would look like this: