I have inherited an excel spreadsheet that has a column with both the date
and time in it followed by the abbreviation PDT ( pacific daylight time). I
would like to use a formula to change the column A entry to two columns
.....date and time.

Any help will be greatly appreciated.

Ex;
column A B C
6/4/2008 21:00 PDT change to 6/4/2008 21:00