Time converting

[Anonymous]

Helloo, 

I'm beginner to PowerBi, I have this type format on Excel ( [h]:mm:ss) I would like to know how to have the same format?

thks 🙂

[amitchandak]

@Anonymous , Change the data type to Time. You should be able to that in Column tools in data view

[Anonymous]

I've done this before and didn't get the result I'm looking for. I used this code to convert to Datetime but the result is not good

[amitchandak]

@Anonymous , if the first column is datetime, then this should work. It is case sensitive

DateTime.ToText([Column1], "HH:mm:ss")

.