B2 =INT(A2)
C2 =MOD(A2,1)
Format each cell appropriately.

as an alternative, you could, of course, have =A2 in both B2 and C2, and
format each to show only the relevant part, but that would still leave the
two cells both containing date and time (and merely displaying the subset).
--
David Biddulph

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