I have a list of times that in my query that are currently recognized as text. Examples:
2A
2:30P
2:45P
2P
2:15P
2:30P
How do I convert them to 24 hour time or a readable time format 2:00 AM 2:00PM etc.
I am new to Power BI so please be gentle. Thanks for the help.
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:
Once you change it to time type, you can change the time format any way you like using the format drop-down.
Wow. Thank you Brian. I was really overthinking this problem. Appreciate the help.