0 Replies Latest reply on Jul 13, 2018 4:34 AM by Debayan Roy

    Split data daywise

    Debayan Roy

      Hi All,

       

      I would like a have a simple solution for the problems attached. In the first Excel tab (Input), I have start date and end date of events (eg A,B). And in the second tab (Desired_Output), Duration of each day of these events has been shown. I just have provided an example set, but practically the data is spreaded over more the 3 days. I was trying to do some calculation like DATEDIFF but seems like pivoting all of the dates is bit difficult.

       

      Please let me know any further clarification is needed.

       

      Thanks a lot for your help,

      Roy