Forum Discussion
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" etc. Is there a way to add the 0 prefix to the "9:30" time so that it is "09:00"?
Thanks
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
4 Replies
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
In Power Query, if the data is typed as `time`, it will display in the format of your computer's windows regional settings. If you load it into Power BI, you can set the format for that column (`hh:mm`)
If it is typed as `text`, then you can use the text manipulations discussed by m_dekorte , but you won't be able to perform any calculations.
