Forum Discussion
ChrisDB840
May 02, 2023Copper Contributor
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.
ChrisDB840
May 02, 2023Copper Contributor
Hhhhmmmm . . . that doesn't seem to work. And yes, I am trying to flag start and stop times that are the same.
HansVogelaar
May 03, 2023MVP
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.