You can use the following formula to split a timestamp in Google Sheets into a date column and a time column:

=SPLIT(A2, " ")

This particular formula splits the timestamp in cell **A2** into a date column and a time column.

Note that the **SPLIT** function in Google Sheets divides text around a specific character or string.

In this case, we split the timestamp based on where the space occurs.

Thus, if we have a timestamp of **1/1/2023 4:15:12** then this formula will split it into **1/1/2023** in one column and **4:15:12** in another column since a space separates this date and time.

The following examples show how to use each formula in practice.

**Example: How to Split Date & Time in Google Sheets**

Suppose we have the following column of timestamps in Google Sheets:

Suppose we would like to split the timestamps such that the date portion is shown in one column and the time portion is shown in another column.

We can type the following formula in cell **B2** to do so:

=SPLIT(A2, " ")

We can then click and drag this formula down to each remaining cell in column B:

Notice that the date portion of each timestamp is now shown in column B and the time portion of each timestamp is shown in column C.

**Note**: You can find the complete documentation for the **SPLIT** function in Google Sheets here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Use VLOOKUP by Date

Google Sheets: Calculate Days Between Date and Today

Google Sheets: How to Add & Subtract Years to Date