Assuming the date/time is a true Excel date/time...

A1 = 09/24/09 8:40

B1: =INT(A1)
Format as Date

C1: =MOD(A1,1)
Format as Time

--
Biff
Microsoft Excel MVP


"Dr. Bill" <Dr. wrote in message
...
I need to perform this function using worksheet commands - I do not want to
use the"manuel entry" of a wizard - I need to "split" date and time
(09/24/09
8:40) into two distinct cells...