Trouble getting times to format as HH:MM (24-hour format)

I have a data set with some time values that I can not for the life of me get to format correctly. They originally exported as Date/Time, and when I formatted to time it dropped the Date but formatted them as AM/PM as HH:MM:SS and all I need is 24h time format with HH:MM, here's an example line:

DRV0151303 1/10/2017 DN40025752 8269 12:23:19PM 12:23:31PM 8269 12:37:53PM 12:37:55PM 8269 12:25:06PM 12:33:02PM 8269 12:47:32PM 8269 1:01:11PM

I need to convert all the time values to 24h HH:MM, I've tried formatting a half dozen different ways but can't seem to get them to force correctly.

Again, any help is much appreciated.

dbc42, I updated your title as a courtesy. As a new member, please take the time to review our rules. There aren't many, and they are all important.

Rule 1 of our Forum Rules requires good thread titles.