|  

» 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.
Screenshot // Converting a Number to a Time Value
Converting a Number to a Time Value


Book Store:

VIEW ALL BOOKS

Recommended Books:

Print Tip
Add to My Tips
Rate This Tip
12 34 5
Rating: 2.47     Views: 85162
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)))
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments


Excel 2007 Tutorials


Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation