How to calculate time percentage of number of parts being pick in a timeframe
 

Can someone help me how to calculate the % of boxes being picked by an "order picker" Ex. An "order picker" picked 24 boxes in 28 mins how would I get the percentage of boxes the "order picker" would pick in an hour? I tried (28/24*1440/24) and gives me a total of 70 but i think its off. Please help! Thank you!

Hi Markous,

I may be missing something here, but I'm not really sure I understand exactly what it is you're trying to achieve.

Could you explain in a little more detail what you're trying to do?

I don't get why you're looking at percentages.

If a box picker picks 24 boxes in 28 minutes, you could show at that given point what percentage of his possible hourly number would be, but I doubt that's what you actually mean.

How to calculate time percentage of number of parts being pick in a timeframe
 

"Markous" wrote:
Can someone help me how to calculate the % of boxes being
picked by an "order picker" Ex. An "order picker" picked 24
boxes in 28 mins how would I get the percentage of boxes the
"order picker" would pick in an hour? I tried (28/24*1440/24)

How do you represent 28 mins: by the number 28; or by the time 00:28?

If 24 boxes are picked in 28 mins, then 24*60/28 boxes can be picked in an
hour.

In general, you might want INT(24*60/28) or ROUND(24*60/28,0). The result
is 51.

If you represent time as 00:28 in A1 (hh:mm format), you would compute:

=24*TIME(1,0,0)/A1

As for a percentage of boxes, that would be 51/n, formatted as Percentage,
where n is the total number of boxes. You neglect to say what n is.