» 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:
- Special Edition Using Microsoft Office XP
- Microsoft Excel VBA Programming for the Absolute Beginner
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Adventure Capitalist: The Ultimate Road Trip
- Seven Habits Of Highly Effective People
- Marketing Management
No comments have been submitted.

