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)


      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?