Converting Time again

[PCRIDE]

Hi, I've tried several things and excel is still not seeing the time as time.

The system exports the time data in text in this format, note AM and PM

09:00AM
08:00PM

So its like a hybrid 24 hour normal time. Note there is no space between the AM/PM and the time.

If I click into the time field and add a space and hit enter in Excel, Excel now see's it as time.

What formula is best for this, to retain the AM/PM format?

 

[Dave Patton]

Mark858's suggestion and similar suggestion work

Time 2023.xlsm
	A	B	C
1
2	09:00AM	9:00:00 AM	9:00:00 AM
3	11:12PM	11:12:00 PM	11:12:00 PM
4	08:00PM	8:00:00 PM	8:00:00 PM
5
1h

Cell Formulas
Range	Formula
B2:B4	B2	=--REPLACE(A2,6,0," ")
C2:C4	C2	=--REPLACE(A2,6,," ")