» Adding a Number to a Formatted Time Value
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Creating a formula that will return a time value which is
the sum of the time in A2 and the number of hours in B2.
Solution:
When adding a time value and a number representing hours, we must first divide the number by 24, as shown in the following formula:
=A2+B2/24
Ensure that the result cell is formatted [hh]:mm to correctly display a time.
Time_____Hours to Add___Result
10:30____4.5____________15:00
17:00____5.2____________22:12
14:12____0.6____________14:48
Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Learn MS Excel 2002 VBA/XML Programming
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
Date and time in same cell and want to seprate them
there are thosand of entries on them