How to convert text into time format?

I have excel data file that contains time inserted as text in inconsistent format.

I need a formula that format the any of these time into text in the form: 00:00 AM/PM

sample of the data that I see:

12am "two digits no space between number and am"
7 pm "1 digit with space between number and pm"
8:00pm "no space"

etc.

I need a formula that reads and exracts this type of data and clean it up as "00:00 AM/PM"

One option
=IF(ISNUMBER(FIND("am";A1));--SUBSTITUTE(A1;"am";" am");--SUBSTITUTE(A1;"pm";" pm"))
+ format the cell.
//Ola

If you don't go with the find and replace suggestion, how about:

=IF(ISNUMBER(A2),A2,SUBSTITUTE(A2,RIGHT(A2,2)," "&RIGHT(A2,2))*1)