Ads

split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2 columns

How to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM into 2 columns

Suppose I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM into 2 columns as below:
1. mm/dd/yy

and
2. hh:mm

How do I do it?

Here is the solution:

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


Source