» Entering the Current Time into a Cell
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
To 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:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Investing for Dummies, Third Edition
- The 22 Immutable Laws of Branding
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- How to Pay Zero Taxes (Annual)
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
