Arrow left
Back to product guides
Google Sheets Formulas

How to Insert Current Time with NOW Function in Google Sheets

In this article, you will learn how to insert a current time in a cell automatically by using the NOW function in Google Sheets. The NOW formula shows the current date and time. For example, It is beneficial when you need to record time and date during the data collection process.

How to use the NOW formula in Google Sheets

  1. Select a cell you want to show the date and time.
  2. Type “=NOW()” or navigate to “Insert”“Function”“Date”“NOW”.
  3. Done - You don’t need to input any argument for this formula.
How to insert the NOW function in Google Sheets

Look at how you can use the formula practically. Assume you need to collect some data with its collection date and time. 

  1. Insert the NOW function in a cell.
  2. Prepare the table to organize the data, make cells for data input blank, and fill cells for date and time by the absolute reference to the cell containing the NOW formula, as shown in the picture below.
  3. When you collect data next time, once you input the data in cell B7, which is surrounded by green lines, you can make a date and time in cell C7, enclosed by red lines, a value by special paste functions (value only and format only)
How to use the NOW formula with an example

Note:

  1. We used the default formatting of the NOW function, but you can change it by using the “Custom date and time” formatting. (“Format”“Number”“Custom date and time”)
  2. If you don’t need time recording, you can use the TODAY function instead.

Other formulas related to date and time

If you don’t get the right answer to your question in this article or you have other questions related to date and/or time, you may find the answers in the following articles.

Formulas related to dates

How to Use EDATE Function in Google Sheets - understand a date before/after a specific number of days

EOMONTH Function in Google Sheets: Explained - understand an end date of a month

DATEVALUE Function in Google Sheets: Explained - convert a date into a serial number

Analyze your live financial data in a snap

Are you learning this formula to build a or financial KPI dashboard? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711