» Converting a Number to a Time Value
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
To quickly type time values into cells: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:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The 11 Immutable Laws of Internet Branding
- How to Read A Financial Report
- Getting to Yes: Negotiating Agreement Without Giving In
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
No comments have been submitted.
