Change 2a to 02:00 and 2p to 14:00

@Baltimorejack68,

Welcome. This is a quick one. Once you exit Power Query, go to the data table view, select the column you want to format, click on the Modeling tab, select “Time” from the data type drop-down list, and presto:

image

Once you change it to time type, you can change the time format any way you like using the format drop-down.

  • Brian