Finding Overlapping Hours at Specific Intervals

An Excel file that teaches how to perform Finding Overlapping Hours at Specific Intervals operation.

Excel Spreadsheet for Finding Overlapping Hours at Specific Intervals

Start and end times are entered into the table. Intersection control is performed using a logical formula. Overlapping intervals are highlighted in color. Blank records are not taken into account. The report summary shows the total duration.

Hope it is useful.