Forum Discussion

scottm0690's avatar
scottm0690
Frequent Visitor
5 years ago

Converting Seconds into Days, Hours, Min

I found a Dax formula for converting seconds into Hours, Min, seconds but want to also include days.   Not sure how to manipulate the formula for that.  Could use some help.  Here is what I have, please help.  Thanks

 

Time Left = VAR hours =
ROUNDDOWN ( [Actual time left] / 3600, 0 )
VAR minutes =
ROUNDDOWN ( MOD ( [Actual time left], 3600 ) / 60, 0 )
VAR seconds =
INT ( MOD ( [Actual time left], 60 ) )
VAR milliseconds =
round(MOD ( [Actual time left], 1 ) * 100,0)
RETURN
FORMAT(hours,"00") & ":"
& FORMAT(minutes, "00")
& ":"
& FORMAT(seconds, "00")
& "."
& FORMAT(milliseconds, "00")

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    scottm0690 , Add days too in calculations

     

    Time Left =
    VAR Days =
    ROUNDDOWN ( [Actual time left] / 3600*24, 0 )
    VAR hours =
    ROUNDDOWN ( MOD([Actual time left],3600*24 )/ 3600, 0 )
    VAR minutes =
    ROUNDDOWN ( MOD ( [Actual time left], 3600 ) / 60, 0 )
    VAR seconds =
    INT ( MOD ( [Actual time left], 60 ) )
    VAR milliseconds =
    round(MOD ( [Actual time left], 1 ) * 100,0)
    RETURN
    FORMAT(Days,"000") & ":"
    FORMAT(hours,"00") & ":"
    & FORMAT(minutes, "00")
    & ":"
    & FORMAT(seconds, "00")
    & "."
    & FORMAT(milliseconds, "00")