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

--
Kind regards,

Niek Otten

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