» Entering Times Quickly
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Entering times quickly, without having to use a colon to separate hours and minutes.
Solution:
Use the TIMEVALUE, IF, LEFT, and RIGHT functions as shown in the following formula:
=TIMEVALUE(IF(A2<1000, LEFT(A2,1),LEFT(A2,2))&":"&RIGHT(A2,2))
Enter the above formula in column B and format the cells as "hh:mm".
The formula will convert each numerical value in column A to a properly formatted time value.
Book Store:
Recommended Books:
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Marketing Plan: A Handbook with Marketing Plan
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Monte Carlo Methods in Finance
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
No comments have been submitted.
