Split a date/time column into 2 columns

I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2
columns
1. mm/dd/yy and 2. hh:mm

I'm using excel 2003

1. =int(A1), format as date
2. =MOD(A1,1), format as time

--
Kind regards,

Niek Otten

"RKMiller" <RKMiller@discussions.microsoft.com> wrote in message
news:0B5A5293-95C4-4C12-8843-9E8108E92257@microsoft.com...
>I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2
> columns
> 1. mm/dd/yy and 2. hh:mm
>
> I'm using excel 2003