Minute Decimal number to HH:MM:SS

[Anonymous]

Hi!

I've got a measure containing the following formula 

TRUCK_TVT_95PERCENTILE = CALCULATE(PERCENTILE.EXC(Truck_Visits[TVTinMinutes];0,95))

I want to format this number into HH:mm:ss. 

How do I do this?

See attached printscreen for sample data.

[v-shex-msft]

Hi @Anonymous ,

You can try to use following calculated column if it is suitable for your requirement:

Decimal to HMS =
VAR _original = Table[Value] / 0.95
VAR _second =
    INT ( MOD ( _original, 1 ) * 60 )
VAR _minute =
    MOD ( ROUND ( _original, 0 ), 60 )
VAR _hour =
    INT ( _original / 60 )
RETURN
    _hour & ":"
        & IF ( _minute < 10, "0" & _minute, _minute ) & ":"
        & IF ( _second < 10, "0" & _second, _second )

Notice: if you do not need to calculate on original result, you can remove first variable and directly use your column in expression.

Regards,

Xiaoxin Sheng

[jthomson]

Knowing if that's 42.88 hours or 42.88 minutes would be a start

[Anonymous]

It's 42.88 minutes.