Changing date/time format

All,

I have been racking my brain out on this for several hours and have no answer, but know there must be an easier way to do this.

I receive a CSV file and there are 3 columns labeled Call date, PartStarttime, & PartEndTime. Each of these columns is formated as general (because it is coming from a CSV file) and they represent the date and time (DD/MM/YYYY hh:mm:ss AM/PM).

I need to reformat each of these so that Call Date is in the U.S. format of MM/DD/YYYY hh:mm:ss 24hr and the other 2 are simply just the time in 24 hour.

I have attached it here and would appreciate any help.

I have tried the Data-->Texts to Column, but that did not work.

thanks
Mike