Convert time 011006 in hrs:min:sec

[momodj20]

i convert the number 060025 in hrs:min:sec

in access i convert with this formulas

CDate(Format([irorim];"00""  : ""00""  : ""00"))

how do I convert in dax?

thanks

Maurizio

[Anonymous · Accepted solution]

This could work:

Column = TIME(LEFT(Table1[Column1],2),MID(Table1[Column1],3,2),RIGHT(Table1[Column1],2))

Make sure the new column has the right format

[Anonymous · Accepted solution]

This could work:

Column = TIME(LEFT(Table1[Column1],2),MID(Table1[Column1],3,2),RIGHT(Table1[Column1],2))

Make sure the new column has the right format

[momodj20]

Excuse me but the time not is 011006 but 11006 and not function.
Can i convert in 011006 and subsequently Apply your formula?
how do I convert the field to 011006?
Very very Thanks

[Anonymous]

as long as your data has 6 digits this formula will work. can you send me the sammple of your data?

[momodj20]

My field are decimal 6 - 13005

I have a convert in string ‘000000’ and other convert in time .
The query not function because the field not has 6 digits.

[v-chuncz-msft · Accepted solution]

@momodj20,

Just use FORMAT first.

Column =
FORMAT ( Table1[Column1], "000000" )