» 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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Analyzing Markets, Products, and Marketing Plans
- Learn MS Excel 2002 VBA/XML Programming
- Microsoft Office XP Introductory Concepts and Techniques
- Harry Potter and the Order of the Phoenix (Book 5)
- Keys to Reading an Annual Report (Barron's Business Keys)
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)))
