» 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:
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Analyzing Markets, Products, and Marketing Plans
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
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