Timestamps are DateTime values in Google Sheets. These are combined values storing date and time. There are instances when we only need the date, not the time and vice versa.
In this tutorial, we will learn 3 methods for separating date and time from timestamps in google sheets.
Suppose you have the following table with Timestamp (Date and Time) on Column A, and you want to separate the date and time into columns B and C, respectively.
The SPLIT function can split the contents of a cell into multiple cells. Since the timestamp is composed of Date and Time, we can use the SPLIT function to extract the Date to one cell and Time to another cell.
Here are the steps:
In the internal google sheet system, the date is stored as a whole number and the time is stored as a decimal or as a fractional part. As such, we can extract the date from the timestamp by getting the whole number and the time by retrieving the fractional part.
To do that, we can use the INT function. The INT function rounds a number down to the nearest integer.
Here are the steps:
You can easily separate the date and time by just changing the format of the cells.
Using any of these 3 methods, our first table above will become
If you wish to change the format of the date and time, highlight the cells you wish to change, go to the 123 icon on the spreadsheet toolbar. Click More Formats, and then select More date and time formats.
After clicking More date and time formats, this window will appear. Choose among the possible date or time formats. Then, click Apply.
How to Add a Secondary Axis in Google Sheets (2025 Update)
Dark Mode for Spreadsheets: The Ultimate Guide [2025]