App Tutorial

Extract Date & Time from Google Sheets: A Step-by-Step Guide

Jason Gong
App automation expert
Apps used
Google Sheets
April 15, 2024

Extracting date and time from Google Sheets involves using functions like SPLIT and INT, or by customizing cell formats. Methods include splitting timestamps, isolating date or time components, and applying specific date/time formats for display flexibility.

These techniques enable precise data manipulation and presentation in Google Sheets.

Enhance your Google Sheets data management by learning to automate with Bardeen, streamlining tasks without manual formulas.

Google Sheets Extract Date from Timestamp

To extract the date from a timestamp in Google Sheets, you can use various methods. One common approach is the SPLIT function. For example, if you have a timestamp in cell A2, you can type '=SPLIT(A2, " ")' in cell B2. This formula will split the timestamp at the space, placing the date in cell B2 and the time in cell C2. Another method involves the INT function, which can be used to extract the date part of a timestamp by rounding down to the nearest whole number. For instance, '=INT(A2)' in cell B2 will give you the date component of the timestamp in cell A2. Remember to adjust the cell format to Date after using the INT function to ensure the output is displayed correctly.

Automate your Google Sheets tasks with Bardeen to save time and improve accuracy. Explore Google Sheets automations.

Google Sheets Extract Time from Datetime

To extract the time from a datetime value in Google Sheets, you can subtract the INT part of the datetime from the original datetime value. For example, if you have a datetime in cell A2, typing '=A2-INT(A2)' in cell C2 will give you the time component. Ensure you format cell C2 as Time to display the output correctly. This method effectively isolates the time part by removing the date component.

How to Separate Date and Time in Google Sheets

Separating date and time in Google Sheets can be achieved through functions or by changing cell formats. The SPLIT function is a straightforward way to divide a timestamp into separate date and time components by using a space as the delimiter. Alternatively, using the INT function for the date and subtracting this value from the original datetime to get the time are effective methods. Additionally, you can use the Format menu to change the cell format to either Date or Time, depending on what component you need to extract. This approach does not require formulas but changes how the data is displayed.

Google Sheets Date Time Format

Formatting date and time in Google Sheets can be customized through the Format menu. To apply a specific date or time format, select the cells you wish to format, go to Format > Number, and choose from the available date or time formats. For more customized options, select More Formats > More date and time formats. Here, you can create your own format by combining different date and time components. This feature allows for a high degree of flexibility in how you display datetime values in your sheets.

For more insights on enhancing your Google Sheets experience, check out our blog posts on Google Sheets addons, Google Sheet automations, and discover a wide range of Google Sheets automations to streamline your data management tasks.

Automate Google Sheets with Bardeen Playbooks

While extracting date and time from Google Sheets can be handled manually using various functions, automating this process can significantly enhance productivity and accuracy. Bardeen offers innovative solutions to automate tasks involving Google Sheets, streamlining data management tasks without the need for complex formulas or manual data entry.

Consider leveraging Bardeen's powerful playbooks for your Google Sheets data manipulation:

  1. Save data from the Google News page to Google Sheets: This playbook automates the extraction of news data from Google News, saving valuable information directly into Google Sheets. It's perfect for keeping up with current events or conducting market research efficiently.
  2. Copy Google News for a keyword and save results to Google Sheets: Tailored for targeted news collection, this playbook extracts Google News results based on specified keywords and saves them into Google Sheets, enabling focused research and data aggregation.
  3. Get data from the currently opened Youtube history page and save to Google Sheets: Ideal for content creators and marketers, this playbook extracts data from the YouTube history page, providing insights into viewing trends and preferences directly in Google Sheets.

Enhance your data extraction and management processes by exploring these Bardeen playbooks, designed to automate and streamline your workflow. Start by downloading the Bardeen app at

Other answers for Google Sheets

How to Disable Download Option in Google Sheets

Learn how to disable downloads in Google Sheets by adjusting share permissions and protecting sheets, enhancing data security.

Read more
How to Download Specific Parts of Google Sheets

Learn how to download specific parts of Google Sheets using the sheet's GID for efficient data sharing and analysis. Streamline your workflow today.

Read more
How to Download Images and Charts from Google Sheets

Learn how to download images and charts from Google Sheets directly or from a URL list to Google Drive, including step-by-step instructions.

Read more
How to Convert Google Sheets to Excel

Learn to download Excel from Google Sheets in a few steps, ensuring file compatibility and offline access. Perfect for Excel users.

Read more
Effective Methods to Convert Numeric Dates to Written Months

Learn how to convert numeric dates to written months in Google Sheets using TEXT function, custom formatting, and more for enhanced data presentation.

Read more
Convert Time to Text in Google Sheets

Learn how to convert time to text in Google Sheets using the TEXT function and built-in formatting options for clear data presentation.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.