How about text to columns, using delimiters, and find replace AM and then PM with a blank.
Then format that column special h:mm.

__________________
RaceCensus - powerful system testing software.
Now with over 400,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/04/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg