The only mistake you are making is in the formula:
=D2*D3*24

Change it to:
=D3/(D2*24)


- Mangesh




"Dean" wrote in message
...
No.
A pick qty of 72 in 30 seconds should give a pick rate of 8640 units per
hour.


"Peo Sjoblom" wrote:

Are you saying that pick qty of 72 for 30 minutes should be 8640 per
hour?
One hour is 60 minutes so the pick raten per hour should be 144 or did
you
just explain it incorrectly? To get the qty per hour divide instead use
=D3/(D2*24) which of course gives 120 qty per hour if pick rate is 90
for 45
minutes, format as general


Regards,

Peo Sjoblom



"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.