Table of Contents
In Google Sheets, you can easily split a date and time into separate cells using the “Split Text to Columns” feature. This allows you to manipulate and analyze the date and time data separately. For example, if you have a cell with the date and time in the format of “12/31/2020 10:30 AM”, you can split it into two cells with “12/31/2020” in one cell and “10:30 AM” in the other. This feature is useful for organizing and sorting data, as well as performing calculations on specific dates or times. To use this feature, select the cell containing the date and time, go to the “Data” tab, and click on “Split Text to Columns”. Then, choose the delimiter (such as a space or comma) that separates the date and time, and select “Split into columns”. This will automatically split the data into two separate cells.
Split Date & Time in Google Sheets (With Example)
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 .
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I split date and time in Google Sheets, with an example?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-split-date-and-time-in-google-sheets-with-an-example/
stats writer. "How can I split date and time in Google Sheets, with an example?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-split-date-and-time-in-google-sheets-with-an-example/.
stats writer. "How can I split date and time in Google Sheets, with an example?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-split-date-and-time-in-google-sheets-with-an-example/.
stats writer (2024) 'How can I split date and time in Google Sheets, with an example?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-split-date-and-time-in-google-sheets-with-an-example/.
[1] stats writer, "How can I split date and time in Google Sheets, with an example?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I split date and time in Google Sheets, with an example?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.