In both cells (B1 and C1) enter =A1
Now format B1 to show the date only; click cell; use CTRL+ 1 to open the
format dialog; select Date from the left side and from the right side of
dialog chose how you want to see the date
Format C1 to show only time
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ferde" wrote in message
...
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