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
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
