Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!
|
#2
|
|||
|
|||
Quote:
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Percentage of time | Excel Discussion (Misc queries) | |||
Calculate Percentage Based On Number | Excel Discussion (Misc queries) | |||
SUMIF to calculate units sold in a specified timeframe | Excel Worksheet Functions | |||
Calculate percentage of time period | Excel Worksheet Functions | |||
Calculate number based on percentage | Excel Worksheet Functions |