» Separating Dates and Times
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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".
Book Store:
No comments have been submitted.

