Forum Discussion

AparnaJ's avatar
AparnaJ
Helper I
7 years ago
Solved

Convert text to time

Hi,   Have a file as below:   Seconds 300 814000   Am trying to create a new column using DAX as below: -------------------------------------------------------------------------------------...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi AparnaJ 

    Create columns

    Time Format = 
Var H = MOD(INT(Sheet1[Seconds]/3600),24)
Var M = FORMAT(INT(DIVIDE(MOD(Sheet1[Seconds],3600),60)), "00")
Var S = FORMAT(INT(MOD(MOD([Seconds],3600),60)),"00")
RETURN
H& ":" & M & ":" & S

day = INT(INT(Sheet1[Seconds]/3600)/24)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi AparnaJ 

Create columns

Time Format = 
Var H = MOD(INT(Sheet1[Seconds]/3600),24)
Var M = FORMAT(INT(DIVIDE(MOD(Sheet1[Seconds],3600),60)), "00")
Var S = FORMAT(INT(MOD(MOD([Seconds],3600),60)),"00")
RETURN
H& ":" & M & ":" & S

day = INT(INT(Sheet1[Seconds]/3600)/24)

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tani4ka's avatar
Tani4ka
Helper II
5 years ago

This doesn't seem to work in my case since I have cells with no values. How to get along this one?

Many thanks