» 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:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Positioning: The Battle for Your Mind
- The Ernst & Young Business Plan Guide
- Advanced modelling in finance using Excel and VBA
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Total Money Makeover. : A Proven Plan for Financial Fitness
A easier way
David Haddon
with the value of 23:42 in cell A1 the formula is
=(A1*24*60)/1440 to give an answer of 0.9875
=(A1*24*60)/1440 to give an answer of 0.9875