5 Replies Latest reply on Aug 27, 2018 5:47 AM by Tobias Schubert

    Calculate duration with different days

    Tobias Schubert

      Hi Com,

       

      I'm trying the following, without success until now:

       

      I got two colums from my data which contain start-date and end-date of a system process.

      The format is like this: DD.MM.YYYY HH:MM:SS

       

      I would like to have a calculation of the duration from start to end.

      How should I do it so I also get the time difference including possible day differences.

       

      Example:

      start:                     01.10.2018 08:00:00

      end:                      02.10.2018 09:00:00

      expected result:    25:00:00

       

      Thanks in advance!