» Converting a Number to a Time Value
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
Enter the following formula:
=IF(A31000,TIMEVALUE(LEFT(A3,1)&":"&RIGHT(A3,2)),TIMEVALUE(LEFT(A3,2)&":"&RIGHT(A3,2)))
The formatting of the cells in column B is HH:MM.
Book Store:
Recommended Books:
- Wall Street Journal Guide to Understanding Money and Investing
- Learn MS Excel 2002 VBA/XML Programming
- Financial Risk Manager Handbook, Second Edition
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Not-for-Profit Accounting Made Easy
Error in formula
Matt F
There is an error in the formula but the correct formula is on the screen shot. Correct formula should be =IF(A3<1000,TIMEVALUE(LEFT(A3,1)&":"&RIGHT(A3,2)),TIMEVALUE(LEFT(A3,2)&":"&RIGHT(A3,2)))
