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 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!
 
 
 

 

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 )

5 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    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 )

    • perfectreign's avatar
      perfectreign
      Frequent Visitor
      2 years ago

      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.)

       

  • 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