convert to time format

[anto1510]

Hi All,
I have attached a file.I exported the file and it is whoing it in a different format.
Could you please how to change it to time format.

[DonkeyOte]

Run an Edit -> Replace on Column A replacing AM with _AM where _ is a space.
Repeat for PM.

Alternatively - if you wish you could combine A & B into a single DateTime stamp in a new Column via formulae:

C2: 
=B2+REPLACE(A2,FIND("M",A2)-1,0," ")
copied down