Times in Power Query

[cmcnally]

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

[ronrsnfld]

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.

[cmcnally]

Thank you @ronrsnfld 

[m_dekorte · Accepted solution]

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

[cmcnally]

Thank you @m_dekorte