ExcelBanter - Split a date/time column into 2 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Split a date/time column into 2 columns (https://www.excelbanter.com/excel-discussion-misc-queries/61040-split-date-time-column-into-2-columns.html)

RKMiller

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

Niek Otten

Split a date/time column into 2 columns

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

All times are GMT +1. The time now is 05:25 PM.