5 Replies Latest reply: Mar 16, 2017 6:31 AM by Prem Utukuri RSS

    Hi friends, How to show values in Minutes? I have the data in Seconds

    John Blomqvist

      Hi all,

       

      I have some data where the time difference is calculated in seconds

       

      DateDuration (Seconds)
      01/03/20171403
      13/03/201735
      10/03/201718
      01/01/20171026

       

      At the moment I am calculating as Sum(Duration) / 60.

       

      This works for values over a minute(e.g. for the first and last values in the above table) but it doesn't show me the values in seconds if the duration is less than a minute (e.g. 2nd and 3rd row above).

       

      Any idea how I can get around this properly?