one method
if 5/31/07 is in A2
in b2 enter =A3
copy B2 and B3 and paste form B4 to the end of your data
Use autofilter on column B and select non-blanks.


"Constance" wrote:

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