Duration hh:mm

[Novice_92]

Morning everyone,

I'm looking to convert whole number into hh:mm without it converting into d:hh:mm when it exceeds 24hrs via DAX.

Any ideas?

TIA

[AlexisOlson]

Can you give a few examples? Is the whole number in units of days, hours, minutes, or something else?

[Novice_92]

Hi,

whole number in this case = seconds and require the formula to convert this into hours & minutes. 

[AlexisOlson]

Try something like this:

Duration (hh:mm:ss) = 
VAR _Seconds = Table1[Seconds]
VAR _Hours = INT ( _Seconds / 3600 )
VAR _Remainder = ( _Seconds - _Hours * 3600 ) / 3600 / 24
RETURN
    FORMAT ( _Hours, "00:" ) & FORMAT ( _Remainder, "nn:ss" )

You can drop the ":ss" if you just want "hh:mm".

[Tahreem24]

@Novice_92 Try this:

Duration =FORMAT(Table[ColumnName] / 60 / 24, "h:mm")