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

[jblomqvist]

Hi all,

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

Date	Duration (Seconds)
01/03/2017	1403
13/03/2017	35
10/03/2017	18
01/01/2017	1026

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?

[sunny_talwar]

May be like this

Interval(Interval#(Sum(Duration), 'ss'), 'mm:ss')

[swuehl]

Maybe

If(Sum(Duration)>=60, Sum(Duration) / 60, Sum(Duration) )

?

But this will mix values minutes and seconds in the same field, I don't recommend to do that.

Maybe just show

Sum(Duration) / 60

with decimal places?

[rahulpawarb]

Hello John,

Referring solution given by stalwar1‌ I have prepared sample application. Please find attached herewith.

Regards!

Rahul

[#5]

Hi,

try this in your expression

=Num(Duration/60,0) & ':' & mod(Duration,60)

hope this helps

thanks

[#6]

Hi,

if you want to show two digits in  min and secs

try this in your expression

=Num(Duration/60,00) & ':' & Num( mod(Duration,60),00)

hope this helps

thanks