» Calculating the Number of Hours Worked Based on a System of Letter Codes
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Column B contains a list of letters which are codes for the hours worked on each of the days listed in column A.
"N" indicates a 9 hour day, "H" indicates a 4 hour day and "V" indicates no hours were worked that day.
We want to calculate the total number of hours worked during the week.
Solution:
Use the COUNTIF function as shown in the following Formula:
=COUNTIF(B2:B8,"N")*9+COUNTIF(B2:B8,"H")*4
Book Store:
Recommended Books:
- Excel Charts
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The 11 Immutable Laws of Internet Branding
- Wall Street Journal Guide to Understanding Money and Investing
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
