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

    Identifying Overlapping Timeframes


      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