I have text in one column that has times formatted as "1230 pm" and need to convert it to time.
I managed to convert the "am" data but didn't get it to work with the "pm" data.
If the text is in A1, then you can format a cell for the time format you want, and use this formula:
Make sure you format the cell as time format otherwise you'll get a funky decimal. Also, this only works if the space is between the number and the am/pm.