» Calculating Hourly Productivity
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Column B contains time values representing the hours worked by each salesperson in column A.
Column C shows the number of items each salesperson sold during that time.
We want to calculate the hourly productivity (Items Sold/Hours Worked) for each salesperson.
Solution:
As time values in Excel are stored as fractions of 24 (an entire day), we must first multiply the times in column B by 24 in order to convert them to decimal values.
Hence, we calculate productivity as shown in the following formula:
=C2/(B2*24)
Book Store:
Recommended Books:
- Seven Habits Of Highly Effective People
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Financial Reporting and Analysis (2nd Edition)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
tania
Hi- how do i calculate hours worked?
example: Sally Monday 11:00A-6:15P, (column A1) :1:00P-2:0P lunch, (column A2) Tuesday 12:00p-5:00p, (column B1): 2:00P-3:00P Lunch, (column B2)
Excel total hours worked
hubert.folmli
Colum A: Started work at 8:00:00AM
Colum B: Finished work at 5:00:00PM
Colum C: What formula is being written for to get total of hours worked
For example
Column A contains No. of Records
- 500
Column B contains Tot. Time Taken
- 15:30
using formula
=A1/(B1*24) the result in Column C1 is 32.26
manual calculation
=500/15.30 the result in Column C1 is 32.68
Why the net result of formula calculation and manual calculation are mismatching?
Sathish Kumar H