7 Replies Latest reply on Feb 6, 2019 5:06 AM by Zhouyi Zhang

    How to calculate duration in between rows?

    Andreas Grossmann

      Hi all,
      I have a problem while crating a Gantt chart. But I guess the issue is related to my data:

      I have a spread sheet describing what is going in and out of a warehouse. Basically three columns (item serial number, date, direction). Item serial number describes the item going into or out of the warehouse. Date is the column saying when the change happend and direction says if it has moved into or out of the warehouse.

      The issue is that I have not one line with the in- and out date which allows me to calculate the duration the item was in warehouse to show this in a Gannt. How could I overcome this? It seems I need a calculation referring to the line "before" or "after" of the same serial number...