» Multiplying time values and numbers.
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Column C:C contains time values representing worked hours. Column D:D contains rates.
In order to calculate the payment, we would have to multiply each time value by its matching numerical rate.
Solution:
To calculate the payment, the time value must be multiplied by 24 as well as by the rate, as follows:
=A2*B2*24
Hours___Rate____Payment
22:00___$20_____440
14:00___$25_____350
27:00___$30_____810

Book Store:
Recommended Books:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Accounting the Easy Way
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.


