# Excel Split Date and Time

Last Updated on 31/03/2024

In Excel, if you have in a cell with date and time (like the use of the NOW function) it's easy to split them with only 2 formulas.

How to split the date and the time from an Excel cell?

1. Use the INT function

The INT function will be useful for extracting the date only

2. Write a subtraction to extract the time

Then, to remove the date, a basic operation of subtraction will return the time

## Your cells have Date and Time

Let's start from the following document where you have in column A Date & Time

To display in the same cell Date & Time, we have use this custom date format

We want to split

1. The date in column B
2. And the time in column C
• To perform this separation, it's important to remember:
• 1 represents 1 day.
• Time is a fraction of a day; for instance, 0.33333 equals 8 hours (1/3 of a day).
• Take a look at this article regarding the Date format and Time format.

## Step 1: Extract only the date

So, to extract the date, you just have to insert your value in column A in the INT function.

INT means integer, so you extract the whole part of the cell in column A. And the whole number is the date (the decimal part is the time).

It is possible that you need to change the format of column B to display the format 'Date'.

## Step 2: Extract the time

To obtain the time, subtract the data in column A from the total value computed in column B.

=A2-B2

Again, it is possible that you have to change the format of column C to display the cell format to 'Time'

## Extract only the Time

If you want to extract only the Time, without extracting the date, you can do it with this formula.

=A2-INT(A2)

## Split Date and Time with Power Query

Have you heard about Power Query? It's the tool that transforms your data without a formula in Excel

You can find in this step-by-step guide, how to split date and time with Power Query.

## Frédéric LE GUEN

1. Situ
21/01/2022 @ 14:59

Can you please tell me how to split Dec 25, 2019 - 11:17 PM into date in separate column?

2. shiva
17/07/2021 @ 11:36

how to split Date from a sentence in excel

• Frédéric LE GUEN
19/08/2021 @ 07:05

# Excel Split Date and Time

Last Updated on 31/03/2024

In Excel, if you have in a cell with date and time (like the use of the NOW function) it's easy to split them with only 2 formulas.

How to split the date and the time from an Excel cell?

1. Use the INT function

The INT function will be useful for extracting the date only

2. Write a subtraction to extract the time

Then, to remove the date, a basic operation of subtraction will return the time

## Your cells have Date and Time

Let's start from the following document where you have in column A Date & Time

To display in the same cell Date & Time, we have use this custom date format

We want to split

1. The date in column B
2. And the time in column C
• To perform this separation, it's important to remember:
• 1 represents 1 day.
• Time is a fraction of a day; for instance, 0.33333 equals 8 hours (1/3 of a day).
• Take a look at this article regarding the Date format and Time format.

## Step 1: Extract only the date

So, to extract the date, you just have to insert your value in column A in the INT function.

INT means integer, so you extract the whole part of the cell in column A. And the whole number is the date (the decimal part is the time).

It is possible that you need to change the format of column B to display the format 'Date'.

## Step 2: Extract the time

To obtain the time, subtract the data in column A from the total value computed in column B.

=A2-B2

Again, it is possible that you have to change the format of column C to display the cell format to 'Time'

## Extract only the Time

If you want to extract only the Time, without extracting the date, you can do it with this formula.

=A2-INT(A2)

## Split Date and Time with Power Query

Have you heard about Power Query? It's the tool that transforms your data without a formula in Excel

You can find in this step-by-step guide, how to split date and time with Power Query.

1. Situ
21/01/2022 @ 14:59

Can you please tell me how to split Dec 25, 2019 - 11:17 PM into date in separate column?

2. shiva
17/07/2021 @ 11:36

how to split Date from a sentence in excel

• Frédéric LE GUEN
19/08/2021 @ 07:05