Forum Discussion

cmcnally's avatar
cmcnally
Frequent Visitor
2 years ago
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"...
Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    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

ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

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.