4 Replies Latest reply on Nov 12, 2018 5:20 PM by Angela.Koh

    Identifying Overlapping Timeframes

    Angela.Koh

      Hi All

       

      Am stuck with this problem on identifying overlapping timeframes.

      I know there are solutions posted before but they are either SQL or finding overlaps by [Day] instead of specific timeframe.

      Hope you guys can help me out on this!

       

      I am looking to identify these interactions that are overlapped. By user level only...

       

      This is what one of the solution i have found online but it is not working for me

      I have attached both my workbook and the solution here.

       

      Paging for some honorable experts who have helped me before

      Simon Runc  Zhouyi Zhang