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:

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:

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: