» Displaying the Serial Number Behind the Time
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
Using keyboard shortcutsThe time's serial number is between 0 and 1 (noon serial time = 0.50).
To display the serial number behind the time:
1. Press Ctrl+Shift+; to insert the current time into cell A1.
2. Press Ctrl+` to display the serial number of the current time.
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
