cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Formatting time value from "hh:mm:ss" to "hh:mm AM/PM"

Hey,

Is it possible to change the time format value from "hh:mm:ss" to "hh:mm AM/PM" (24 hours) in Power Query?

Thanks, Ido

2 ACCEPTED SOLUTIONS
Super User IV
Super User IV

You can just choose that format for that column once the table is loaded on the Column Tools tab.

mahoneypat_0-1606588421303.png

 

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Hi @buser1 ,
Ok found a way to do this in Power Query, by selecting your column and selecting Format - Trim.  If you are on the Add Column tab it will place it in a new column.  If you are on the Transform Tab, it will change the column that you selected.  However it changes it to Text.  Then if that will work for you for whatever additional transformations, you need to do in Power Query great! If however you bring it down to Power BI and need to change it back into Time, you can select that format. Please see below:

time no sec.PNG

 

time no sec1.PNG


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Super User IV
Super User IV

You can just choose that format for that column once the table is loaded on the Column Tools tab.

mahoneypat_0-1606588421303.png

 

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Super User I
Super User I

Hi @buser1 ,

In PQ try this. You may have to convert the column to text.

 

24time3.PNG

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi, thanks for the response.
I actually need to convert from this specific format:"hh:mm:ss" to "hh:mm AM/PM" (24 hours and without seconds)
Is there a way to do this in PQ or is the only right way to do it in the model?

 

pq.png

Hi @buser1 ,
Ok found a way to do this in Power Query, by selecting your column and selecting Format - Trim.  If you are on the Add Column tab it will place it in a new column.  If you are on the Transform Tab, it will change the column that you selected.  However it changes it to Text.  Then if that will work for you for whatever additional transformations, you need to do in Power Query great! If however you bring it down to Power BI and need to change it back into Time, you can select that format. Please see below:

time no sec.PNG

 

time no sec1.PNG


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors