» Separating Dates and Times

Problem:

The values in column A are combined dates and times.
We want to create two new columns of data: one containing the date and the other containing the time.

Solution:

To extract dates, use the INT function as shown in the following formula:
=INT(A2)
Enter the above formula in column B and format as "mm/dd/yyyy".

To extract times, use the MOD function as shown in the following formula:
=MOD(A2,1)
Enter the above formula in column C and format as "h:mm".