If your value is in A2 and it is a "true" date/time, then in B2 enter:
=A2 and format the cell as a date
and in C2 enter
=A2 and format the cell as a time.


If the value in A2 is just a text string then in B2 enter:
=LEFT(A2,9)
and in C2 enter:
=RIGHT(A2,10)
--
Gary''s Student - gsnu200745


"Wati" wrote:

Hi....

I have the date and time in a cell "9/20/2007 6:49:53 PM". Now, I want the
date and time to be displayed seperately in different cells. Eg:-
B2=9/20/2007(Date only-No Time)
C2=6:49:53 PM(Time only-No Date)

Any help will be appreciated....