Display hh:mm in a matrix from numeric seconds field

[Kinethik]

Hello all,

I'm struggling with this issue where I have a numeric column with "Net worked hours" in seconds that needs to be added by date and user and then displayed as hh:mm in a matrix.
I got everything running well, except that I can't get it to display the hh:mm.
Matrix with Net hours in seconds:

This is what my visual looks like, can anyone please shed a light on how to go about this?

Thanks so much in advance!!

[mdaatifraza5556]

Hi @Kinethik 

Can you please try below steps

1. Create a measure of your seconds
like ---> TotalSecond = sum(seconds)

and then 

TimeFormatted =

VAR TotalSec = [totalsecond]  

VAR Hours = QUOTIENT(TotalSec, 3600)

VAR Minutes = QUOTIENT(MOD(TotalSec, 3600), 60)

RETURN FORMAT(TIME(Hours, Minutes, 0), "hh:mm")


If you got your solution then please accept it as solution.

[Deku · Accepted solution]

If you swap from a implict measures to a explict one you can use dynamic format strings

Measure

SumHours= sum( table[hours]) / 3600

And the format string

Var hours = int( selectedmeasure() )

Var mins = mod( selectedmeasure () )

Return

Hours":"mins