Find Hours That Overlap with Specific Times

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

Excel Spreadsheet for Find Hours That Overlap with Specific Times

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.