Insert Current Time or Today using #Excel functions or shortcuts

Excel Tip - Insert Date Time using shortcuts.PNG

It’s not uncommon to insert a date stamp or time stamp on a spreadsheet.  We may use the following functions to get the results easily:

=TODAY() 'to get the date of today

=NOW() 'to get both the date of today and current time

=TEXT(NOW(),"HH:MM") 'to get just the current time* 
*Tip: If we want to display down to second, use "HH:MM:SS" in the 2nd argument


Example of outputs:

Formula Results
=TODAY() 22/12/2019
=NOW() 22/12/2019 16:59
=TEXT(NOW(),”HH:MM”) 16:59
=TEXT(NOW(),”HH:MM:SS”) 16:59:07

Nevertheless, these functions always update whenever there is change applied to the spreadsheet.  Most of the time, we would like to convert it to a static value by using Copy and Paste value afterward.  We just want to record a moment, not to have “ever-changing” values.  In this case, it’s better to use shortcut keys to insert Today, and Current Time.

And the shortcuts are:

CTRL+; to insert TODAY

CTRL+SHIFT+; to insert current TIME

How about to have both TODAY and current TIME in one cell?

well, there is no such shortcut to my knowledge… but a workaround:

Excel Tip - Insert Date Time using shortcuts

What’s the trick?

Nothing magical but simply press in order:

  1. CTRL+;
  2. (space)
  3. CTRL+SHIFT+;

😁

 

You may also watch it in my YouTube Channel:

 

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, Shortcut and tagged , , , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.