Forum Discussion

JWE's avatar
JWE
Icon for Helper I rankHelper I
9 years ago
Solved

Convert minutes into days and timeformat

Hi folks   I want to convert minutes into readable stuff for the endusers, e.g.: I have 2.480,08 minutes I want to format this in duration (but not in Time-Format) because the value is greater ...
Need Help
  • JWE's avatar
    JWE
    9 years ago

    Hi - thanks, it works. Hopefully the VAR function works quick enough also with big data!

     

    I have modified your DAX, to display the days or not, and hour work day has only 15 hours, so I divide through 900 instead of 1440.

     

    WE Dauer gesamt =
    var Tag=  INT(Lagerbeleg[WE Dauer in Min] / 900)
    var Stunde=  INT(MOD(Lagerbeleg[WE Dauer in Min]; 900) / 60)
    var Minute=  MOD(MOD(Lagerbeleg[WE Dauer in Min]; 900); 60)
    var Sekunde= INT((Lagerbeleg[WE Dauer in Min] - INT(Lagerbeleg[WE Dauer in Min])) * 60)
    return
    IF(Tag = 0; "";
      IF (Tag > 1; Tag & " Tage "; Tag & " Tag "))
    & FORMAT(Stunde; "#00")
    & ":"
    & FORMAT(MINUTE; "#00")
    &":"&
    FORMAT(Sekunde; "#00")

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi JWE,

 

You can try to use belwo formula if it works on your side:

 

Format =
var dayNo=INT([Minutes]/1440)
var hourNo=INT(MOD([Minutes],1440)/60)
var minuteNO=MOD(MOD([Minutes],1440),60)
var secondNo=INT(([Minutes]-INT([Minutes]))*60)
return
dayNo&" day "&FORMAT(hourNo,"#00")&":"&FORMAT(minuteNO,"#00")&":"&FORMAT(secondNo,"#00")

 

 

Regards,

Xiaoxin Sheng

JWE's avatar
JWE
Icon for Helper I rankHelper I
9 years ago

Hi - thanks, it works. Hopefully the VAR function works quick enough also with big data!

 

I have modified your DAX, to display the days or not, and hour work day has only 15 hours, so I divide through 900 instead of 1440.

 

WE Dauer gesamt =
var Tag=  INT(Lagerbeleg[WE Dauer in Min] / 900)
var Stunde=  INT(MOD(Lagerbeleg[WE Dauer in Min]; 900) / 60)
var Minute=  MOD(MOD(Lagerbeleg[WE Dauer in Min]; 900); 60)
var Sekunde= INT((Lagerbeleg[WE Dauer in Min] - INT(Lagerbeleg[WE Dauer in Min])) * 60)
return
IF(Tag = 0; "";
  IF (Tag > 1; Tag & " Tage "; Tag & " Tag "))
& FORMAT(Stunde; "#00")
& ":"
& FORMAT(MINUTE; "#00")
&":"&
FORMAT(Sekunde; "#00")