Forum Discussion
Time converting
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 🙂
Anonymous , Change the data type to Time. You should be able to that in Column tools in data view
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
Anonymous , if the first column is datetime, then this should work. It is case sensitive
DateTime.ToText([Column1], "HH:mm:ss").