In this article:

How to get the Current Time in Google Sheets [2024 Update]

May 8, 2024

In this article we will show you how to get the current time in Google Sheets in just a few clicks. Simply follow the steps below.

Get the Current Time in Google Sheets

For the purpose of the below demonstration an example sheet was created, access this by clicking this link and follow along at home.

We can use the NOW function in Google Sheets to get the current time, in the below example we will demonstrate the use of this useful function.

1. Click an empty cell in your sheet

Click and highlight an empty cell in your sheet. This cell is where the current time will be populated into.

In our example we have selected cell B3.

Google Sheets get current time: Cell selection

2. Input the formula: =TEXT(NOW(),“TIME_TAGS”)

In the empty cell input the NOW formula in the following format:


Formula Breakdown:

=TEXT: This function converts a number into text, the current time is populated using numbers by default.

NOW: This function returns the current time.

TIME_TAGS: These tags are inputted to specify the time data to return. They are enclosed in double quotations (“ ”). 

To return the current date using day, month and year the tag format is:

“YYYY-M-D” (Year - Month - Day)

To return the current time using, seconds, minutes and hours the tag format is:

“HH:MM:SS” (Hours:Minutes:Seconds)

You can change these tags to suit your preferences, as an example you could choose to simply enter “HH:MM” which would just return the Hours and Minutes.

In the example below, we have used the formula to return both the current date and time by entering:


The tags are enclosed in the same double quotations and we have used the separator symbol ( | ) for formatting but this is not required.

Current time Google Sheets: Formula

3. Press Enter and the current time will be populated

With the formula inputted, press the Enter key - the current time will populate in the cell.

As we can see below, the current time and date is populated.

Google Sheets current time: Results

Updating the settings to ensure the current timestamp is updated

Please be aware that the NOW function will only update the current time when the document is changed, for those who do not often make changes this could be an issue as the timestamp may not accurately reflect the most current time. This can be resolved by changing the following settings:

1. Click “File” followed by “Settings”

From the file menu select File, from the menu displayed click Settings

Current time in Google Sheets: File menu

2. Select the “Calculation” tab and expand the “Recalculation” dropdown menu

From the Spreadsheet settings pop up menu that displays click the Calculation tab, in the Calculation section expand the Recalculation menu and choose the interval you would like the current time to be updated:

On change: Refreshes the current time whenever the sheet is edited.

On change and every minute: Updates the current time whenever the sheet is edited AND every minute.

On change and every hour: Refreshes the current time whenever the sheet is edited AND every hour.

Simply click the option to select it.

Google Sheets current time: Recalculation dropdown

3. Click “Save settings” to apply the changes

Select the Save settings button, the changes will be applied and the current time will update to your chosen preferences.

Current time Google Sheets: Save settings
Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->