Excel shortcut: Insert current time

If you want to insert the current time in a cell in Excel, you can use this shortcut:

Ctrl+Shift+. (dot)

Note that this is static. If you want the value to update, you should use the NOW function, which returns date and time, or =NOW()-TODAY() to return the time (apply time format).

Insert current time in Excel: Ctrl+Shift+.
Insert current time in Excel: Ctrl+Shift+.






Leave a Reply

Your email address will not be published. Required fields are marked *