This content has been marked as final. Show 5 replies
I have some data where the time difference is calculated in 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?