How To Separate Dates & Times

Problem: Our values are combined dates and times (column A). We want to separate them in columns B & C: column B containing the date and column C containing the time.

Solution:

Date and time values are stored in Excel as numbers, where the integer part represents the date and the fraction part represents the time.

·         Extracting Dates (Column B)

To extract dates, use the INT function and format as "mm/dd/yyyy".

The INT function rounds the number representing the date and time value to the nearest integer and returns the date.

·         Extracting Times (Column C)

To extract times, use the MOD function and format as "h:mm".

The MOD function divides the number representing the date and time value and returns the remainder - the time.