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

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

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?

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

May be like this

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

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

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?

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

Hello John,

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

Regards!

Rahul

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

Hi,

try this in your expression

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

hope this helps

thanks

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

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