Forum Discussion
Solved
Times in Power Query
Hi All, I'm using an XML feed as a datasource and transforming the data to merge it with another local data source. I have a time field from the XML that is in the format "9:30", "10:30", "18:00"...
Hi cmcnally,
If the column is set to type time as well you can use this function:
Time.ToText([ColName], [Format="hh:mm", Culture="en-US"])Note that this will convert the value to type text:
When the value is already stored as text, then use Text.PadStart, as shown here:
I hope this is helpful
Hi cmcnally,
If the column is set to type time as well you can use this function:
Time.ToText([ColName], [Format="hh:mm", Culture="en-US"])
Note that this will convert the value to type text:
When the value is already stored as text, then use Text.PadStart, as shown here:
I hope this is helpful
