Not clear why you have the formula that you do in D2. What happens when End
time is less than the start time?
Also the rate is usually the number divided by the time. Hence the pick rate
should probably involve dividing D3 with D2?

Alok Joshi

"Dean" wrote:

It's the old time problem.
I want to calculate a persons pick rate. We have
Start time, End time and qty picked
Times are in dd/mm/yyyy hh:mm:ss format
So far I have
A2=17/05/2005 06:00:00 'Start time
B2= 17/05/2005 07:00:00 'End time
C2=B2-A2 'Length of time formatted as dd/hh:mm:ss
D2=B2+1*(B2<A2)-A2 'Length of time formatted as number to 5 decimal places
D3= 'Qty picked
D4=D2*D3*24

A length of time of 0:45 with a pick qty of 90 gives a pick rate of 170
units per hour
but if you change the time to read 00:00:30 and a picked qty of 72 the rate
should be 8640 units per hour but it does not come to that, where am I going
wrong.