» Entering the Current Time into a Cell
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
Using keyboard shortcutsTo enter the current time into a cell:
Select a cell and press Ctrl+Shift+;.
To enter the current time into a cell by using a formula that returns the current date and time:
Enter the formula:
=NOW ()
To get a formula that calculates the current time, change the format of the cell containing the NOW formula to h:mm in the Type box.
Book Store:
Recommended Books:
- Positioning: The Battle for Your Mind
- Special Edition Using Microsoft Office XP
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Seven Habits Of Highly Effective People
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.
