How To Create A Countdown Timer In Google Sheets

Reading Time: 4 minutes

To create a countdown timer in Google Sheets, we use a combination of the three formulas:
(Suppose that A4 is the cell that holds the event date.)
=INT(A4-NOW())
//The INT function rounds down the number to the nearest integer, in this case, the number of days.

=HOUR(A4-NOW())
//The HOUR function returns the hour component from the timestamp.

=MINUTE(A4-NOW())
//Returns the minute component.

Note: To make the timer update automatically, set the spreadsheet to recalculate every minute from the settings.

Get the sample spreadsheet here.

With Google Sheets, one can accomplish a wide range of tasks. From keeping records of sensitive information to just using it as a to-do list. It offers a diverse range of tools to accomplish nearly any task. 

Many people use Google Sheets for tracking their activities to boost their productivity and to be in control of their actions. Wouldn’t it be great if one can also set a deadline to accomplish the set goals? 

Google Sheets lets you create a countdown timer that counts down the days, hours, and minutes until a specific date. We will go through the step-by-step procedure to make a countdown timer in Google Sheets.

Create a countdown timer in Google Sheets  

The countdown timer which we will create in this tutorial will give information about the remaining days, hours, and minutes. Therefore, we will be using 3 different functions to create a countdown timer in Google Sheets. 

In the following example, we have a header called the Event Date which consists of different dates for which we will create their respective countdown timers. 

Example to learn how to create a countdown timer in Google Sheets
Example spreadsheet

The steps are as follows:

  • Select the empty cell under the Days Left header
Select the empty cell as shown
  • Fill in the following formula to calculate the remaining number of days and press Enter
=INT(A4-NOW())
  • Select the empty cell under the Hours Left header
Select the empty cell as shown
  • Fill in the following formula to calculate the remaining number of days and press Enter
=HOUR(A4-NOW())
  • Select the empty cell under the Minutes Left header
Select the empty cell as shown
  • Fill in the following formula to calculate the remaining number of minutes and press Enter
=MINUTE(A4-NOW())
  • Drag the formula of each column to fill the empty cells
Countdown timer implemented successfully in Google Sheets

The output is static i.e. the values will not change on their own. To call this a countdown timer, we will need to make sure that the values update automatically. We will ensure that the countdown timer gets updated every minute. The steps to automate the process are as follows:

  • Click on the File tab and then select the settings options present at the bottom of the dropdown list.
  • In the Calculation tab, click the dropdown button next to Recalculation and choose the On change and every minute option, and then click Save settings. This change in settings will make sure that the countdown timer gets automatically updated every minute.

The countdown timer will automatically update the remaining days, hours, and minutes columns. This way you can easily keep track of the upcoming deadlines.

Conclusion

We have successfully learned how to create a countdown timer in Google Sheets. A countdown timer can help people to track their activities and pace effectively. It’s quite easy to create a countdown timer in Google Sheets and it can help us a lot to boost our productivity. Now you are all set to use this tool to your advantage. If you want to learn more about google sheet countdown timer, our blog section might interest you.

See Also

You have successfully learned how to create a countdown timer in Google Sheets but there is so much more to explore. Are you interested in learning more about how much you can succeed with Google Sheets? With so many powerful features of Google Sheets, you save time and effort.

We have several tutorials that cover tricks and tips in Google Sheets. You can discover them here.

Here are some articles you might be interested in:

https://blog.tryamigo.com/how-to-generate-qr-codes-in-google-sheets/

https://blog.tryamigo.com/sort-query-using-order-by-in-google-sheets/

https://blog.tryamigo.com/introduction-to-date-function-in-google-sheets/