See attached workbook. Basically, it uses the SUMPRODUCT function to count the number of overlapping dates and times (cell E2 no down). However, I need to modify it to take into account another column - employee ID, as illustrated in Cell F2 on down (Overlap 2 - result only though, looking for revised formula).
So basically, it would count the number of overlapping dates and times for each employee. Any ideas? Thanks.
Time.xlsx
Bookmarks