Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

formatting time value to hh:mm:ss

I hope I am posting this to the right location as I am developing a new report.  Anyway, this is coming out of our telephone DB system and one column represented is Duration, which is an int column a...
Mk2018's avatar
Mk2018
Frequent Visitor
8 years ago

Hi

 

I am also experiencing this, have you found any solution for this?

 

Thanks 

bizzybisnette's avatar
bizzybisnette
Frequent Visitor
8 years ago

Guys I think I got it.

 

You need a field that is just seconds and use this code as a measure.

 

Time = FORMAT(INT(

IF(MOD([Seconds]|60)=60|0|MOD([Seconds]|60)) +

IF(MOD(INT([Seconds]/60)|60)=60|0|MOD(INT([Seconds]/60)|60)*100) +

INT([Seconds]/3600)*10000)| "00:00:00")

 

Seconds = the field that contains seconds.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks you! I have just updated a little bit your code to use IT in SSAS :

    =FORMAT(INT( IF(MOD(('WEBSITES KPI'[Temps_passé]/1000),60)=60,0,MOD(('WEBSITES KPI'[Temps_passé]/1000),60)) + IF(MOD(INT(('WEBSITES KPI'[Temps_passé]/1000)/60),60)=60,0,MOD(INT(('WEBSITES KPI'[Temps_passé]/1000)/60),60)*100) + INT(('WEBSITES KPI'[Temps_passé]/1000)/3600)*10000), "00:00:00")

    It's working fine for me 😄 !

    I have divided by 1000 because I have the duration in milisecondes.