Call us: 800-507-1622

Time-Stamping in Google Sheets


Megan Bate

If your business is all about “teamwork makes the dream work,” or involves any form of data entry, writing, editing, etc. – you may be getting increasingly familiar with the Google Docs, Sheets, and Forms. The Google Suite of programs is beautifully intuitive, and makes collaborative work easy.

We’ve found a great tip housed in Google Sheets: data entry, customer service logs, and meeting notes are a few examples of business documents that benefit from a date/time stamp within a spreadsheet. Luckily, Google built in two handy keyboard shortcuts for doing just that!

The cmd + ; shortcut will fill in the current date, formatted as MM/DD/YYYY.

The cmd + shift + ; shortcut will fill in the current time, formatted as HH:MM:SS AM/PM.

Next time you’re using a Google Sheet, save yourself a moment or two and use these helpful keyboard shortcuts!

Want to learn more?

[su_button url=”https://longerdays.com/2018/01/01/take-a-tour-of-our-features/” target=”blank” style=”flat” background=”#2F6690″ size=”10″ center=”yes” radius=”6″]Take a tour of our features![/su_button]