Forum Discussion
Overlapping Times in Excel
I am trying to determine if overlapping times exist in a large data set based on name and date. I am having issues with sumproduct, sort, and filter.
Hhhhmmmm . . . that doesn't seem to work. And yes, I am trying to flag start and stop times that are the same.
Here is a demo workbook with your sample data, and a slightly improved conditional formatting rule. You can view/edit it by selecting Conditional Formatting > Manage Rules... on the Home tab of the ribbon.
