Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help Formatting Time from Minutes

In the report I'm building, I'm given a time duration in minutes.  I want to convert it to days hours:minutes.  (I don't care about seconds.) Based on examples I saw here, I have teh following DAX f...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    the close branket is in the wrong position. you can try to move it to the end.

    VAR days = INT(Elapsed_Time /900 )

gmsamborn's avatar
gmsamborn
Super User
2 years ago

Hi Anonymous 

 

The following is a calculated column to do your conversion.

 

Fmt = 
VAR _TotMin = [Minutes]
VAR _x1 = _TotMin / 1440
VAR _Days = INT( _x1 )
VAR _Remainder = _x1 - _Days
VAR _Hrs = INT( _Remainder * 24 )
VAR _Mins = _TotMin - ( ( _Days * 24 ) +  _Hrs ) * 60
RETURN
    _Days & " d " & _Hrs & " h " & _Mins & " m"

 

 

I hope you are able to adapt this.

 

Formatting Time from Minutes.pbix