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.