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

[buser1]

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

[mahoneypat · Accepted solution]

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

Regards,

Pat

[mahoneypat · Accepted solution]

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

Regards,

Pat

[Nathaniel_C]

Hi @buser1 ,

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

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

[buser1]

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?

[Nathaniel_C · Accepted solution]

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:

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

[leandroab1]

Nice. You can also use:

FORMAT(table[Column1], "h:mm AM/PM")