One way:

XL stores date/times as offsets from a base date - the integer part
being days, the fractional part being time.

B2: =INT(A2)
C2: =MOD(A2,1)

format B2 as a date, C2 as a time.

In article ,
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....