» Convert time to a serial value in Microsoft Excel
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
To covert time into a serial (numerical) value, enter in cell A1: 2342 (this represents the time 23:42)
Enter the following formula in cell B1: =(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))+0
The Result: 0.9875
Please note: The serial value for time ranges between 0 to 1; midnight=0,
24 hours=1
Book Store:
Recommended Books:
- Excel 2002 Power Programming with VBA
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- 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
- The 22 Immutable Laws of Branding
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Learn MS Excel 2002 VBA/XML Programming
No comments have been submitted.
