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\".