Split a date/time column into 2 columns

RKMiller · Dec 19, 2005

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

Niek Otten · Dec 19, 2005

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