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
