HOW TO CREATE A TIMESTAMP IN GOOGLE SHEETS?

Table of Contents

INTRODUCTION

Date and time are very important components in our reports.

These fields are specifically used in the reports comprising time, such as overtime, in out , payment details and more.

Many times we need to make use of the dates over and again specifically the current date.

Similar is the case with the current time.

So, both of these cases are very easy to handle in google sheets as we have the simple shortcuts to create Timestamps in Google Sheets.

In this article, we’ll learn the way to create a time stamp in Google Sheets, the current date or the current time.

WHAT IS A TIME STAMP IN GOOGLE SHEETS?

A time stamp is current date+time combination such as 8/10/2022 22:45:35.

A time stamp provides the precise information about the time including the date and time upto the seconds resolution.

HOW TO CREATE TIMESTAMP IN GOOGLE SHEETS?

We can insert a time stamp in google sheets using two methods.

  1. NOW FUNCTION
  2. USING KEYBOARD SHORTCUT

CREATING A TIME STAMP USING NOW FUNCTION

NOW FUNCTION() is a function which is used without passing any parameters.

We can use it very easily and it’ll put a current stamp in our google sheet.

Use the function as =Now() and press Enter.

The time stamp will be created.

CREATING A TIME STAMP IN GOOGLE SHEETS USING KEYBOARD SHORTCUT

You can create a time stamp in Google Sheets by simply pressing CTRL+SHIFT+ALT+; and the time stamp will be created.



FAQs

HOW TO CREATE A DYNAMIC TIME STAMP IN GOOGLE SHEETS?

Dynamic Time stamp i.e. the time stamp which will change the value every time you load the sheet or perform any refresh function can be created easily using the NOW() Function.

The method is already shared above.

Simply enter the function as =Now() and it’ll insert the time stamp in the given cell.

HOW TO INSERT A TIMESTAMP CONTAINING ONLY CURRENT TIME IN GOOGLE SHEETS?

In addition to the standard shortcut, we have got more combinations for the specific timestamp needs.

Press CTRL+SHIFT+; and the time stamp containing only the current time will be inserted in the selected cell.

HOW TO INSERT A TIMESTAMP CONTAINING ONLY CURRENT DATE IN GOOGLE SHEETS?

Similar to the solution discussed above, we can create timestamp containing only current date in Google Sheets.

Press CTRL+; , and the timestamp showing only date will be inserted in the selected cell.