Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Convert measure value into hh:mm:ss

Hello,   I have a meassure which is SUM(Table1[Field1]) + SUM(Table2[Field2]) Returns a single number like 7685   I need to convert 7685 to HH:MM:SS, how do I do that?   Thanks in advance.
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi sabeensp 

    You may try below measure.

    Measure =
TIME ( 0, 0, 0 )
    + DIVIDE ( SUM ( TABLE1[Column1] ) + SUM ( TABLE2[Column2] ), ( 24 * 60 * 60 ) )

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi sabeensp 

You may try below measure.

Measure =
TIME ( 0, 0, 0 )
    + DIVIDE ( SUM ( TABLE1[Column1] ) + SUM ( TABLE2[Column2] ), ( 24 * 60 * 60 ) )

Regards,

adminbimimed's avatar
adminbimimed
New Member
3 years ago

It worked almost perfectly for me, except that... 🙂

I'm working with call durations in a call center, so it's basically only mm:ss. If I format hh:mm:ss, it shows 00:02:48, but if I format as mm:ss, it shows 12:48 (?!)... I'm guessing that when it is hh:mm:ss, it understand m is for minutes, but if it's formatted mm:ss, it understands m as for month... But I don't know how to solve it... Help! 🙂