» 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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- 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
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
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)))
