Help Formatting Time from Minutes

[Anonymous]

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 forumula:

Time = VAR Elapsed_Time = SELECTEDVALUE('Query1'[SyncTime]) --Get Duration from Current Row

VAR days = INT(Elapsed_Time) /900 --calculate whole days

VAR hrs = (INT(Elapsed_Time) /900/60) --calculate whole hours

VAR mins = hrs * 60 --calculate whole minutes

RETURN

days & " d " & FORMAT(hrs,"00") & " h " & FORMAT(mins,"00") & " m "

What comes back is not how I'd format it. For example, for the duration, 31991 minutes, I get the result 35.545555555556 d 01 h 36 m

Now I think the time calculation is correct, but I only want whole days.  I expect it to be 35 d 01 h 36 m

What am I doing wrong?  Thanks in advance!

[perfectreign]

Thank you all!!!  I have it now.

[gmsamborn]

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

[ryan_mayu · Accepted solution]

@Anonymous 

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

VAR days = INT(Elapsed_Time /900 )

[perfectreign]

That was perfect, thank you!  I now have what I wanted in the report.  You can see in the image that my time now is measured in days, hours, and minutes.  That's perfect. (I don't need seconds.)

[ryan_mayu]

you are welcome