|
» Displaying the Serial Number Behind the Time
CATEGORY: Excel Time |
VERSIONS: All Microsoft Excel Versions |
|
Using keyboard shortcuts The 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. |
| Screenshot // Displaying the Serial Number Behind the Time |
  |
|
RATING:
2.72
VIEWS: 28942 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Financial Reporting and Analysis (2nd Edition)
- Microsoft Outlook 2002 for Dummies
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Keys to Reading an Annual Report (Barron's Business Keys)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
