Shortcut to Enter Current System Time in Excel

Enter Current System Time in Excel – Keyboard Short Key

What is it:

This Keyboard short cut is to enter Current System Time in Excel Cell.

Why:

The Excel formula or function available for the same is

=NOW()

But the above formula or function will include the current Date also along with the Time (Eg:10/13/2014 15:15) and the value will be updated, If you want only the Static Time except the Date (Eg: 3:15 PM) then you should use the below keyboard shortcut.

How:

Use the Ctrl + Shift + : function to enter current system time in Excel Cell

Enter Current System Time_asKeygeek



About Anson

I’m Anson having a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I have got the opportunity to work for Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager. Learning anything new has always been my passion and if related to Business and Technology then I love it. asKeygeek.com is an outcome of my passion towards the same and I have been into asKeygeek since 2012. Outside business and technology I’m a movie buff who spends hours together watching and learning Cinema, I do make Short Films 🙂

One Comment

  1. Pingback: Enter Current System Time in Excel - Keyboard S...

Leave a Reply

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

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