topic How to calculate Decimal number to hours minutes seconds format in Developer

How to calculate Decimal number to hours minutes seconds format

Anonymous — Mon, 22 Nov 2021 12:38:52 GMT

Hi everyone,

Please could i get help to calculate decimal number to hh:mm:ss format.

I've included sample data as well as the output required.

Expected output

Calculated Datacard

Thanks

Vilas

Need Help

Anonymous — Mon, 22 Nov 2021 12:56:00 GMT

VILAS
I am using measure to get the expected output
where table[TVT] is the column contains total view time in sec

time =

var a = SUM('Table'[TVT]) // calculating total view time

var b = MOD(a,60)

var c = QUOTIENT(a,60)

return c & "m " & b & "s"

Anonymous — Tue, 23 Nov 2021 03:23:13 GMT

Thanks Surya

it will working fine

Anonymous — Mon, 29 Nov 2021 13:21:21 GMT

Anonymous Please mark this as a solution