Say your original list is in Column A.

Enter this formula in Say C1:

=INDEX($A:$A,2*ROWS($1:1)+COLUMNS($A:A)-2)

THEN, copy across to D1.

NOW, format C1 to Dates, and D1 to Time.

Select *both* C1 and D1, and drag down the 2 cell selection to copy as
needed.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Constance" wrote in message
...
I have some dates and times in one column that I would like to line up the
dates with the times in the adjacent column. Please see example below:

Present display Would like displayed as this
5/31/07 5/31/07 11:30
11:30 5/31/07 13:20
5/31/07 6/1/07 10:30
13:20 6/1/07 15:30
6/1/07
10:30
6/1/07
15:30

I apreciate the assistance.
--
Constance