Calculating Hourly Productivity

[Sathish Kumar H]

I tried this formula, but the result is mismatching with manual calculations.

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

[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)

[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

[ExcelTip]

Problem:

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)