Forum Discussion

ThisIsVS's avatar
ThisIsVS
Frequent Visitor
3 years ago

Change time format in power query.

How to change time in the "start" column of the following table to show only hours and minutes only.

 

 

For example, In the above image, time shown in the start column is "5:30:00" , What can I do to make it "5:30" provided that the data type of the "start" column should be of "Time" . 

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    I think you are solving this problem in the wrong area.

    You can format the column as 'short time' in powerbi desktop data view.

    • ThisIsVS's avatar
      ThisIsVS
      Frequent Visitor
      3 years ago

      HotChilli Sir, I'm using power query in excel, have to load this data to a table. Although, after loading data to a table, required result can be achieved but I am looking for a method(If there is) to achieve the required result in power query.