LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 829
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Percentage of time FrankTimJr Excel Discussion (Misc queries) 4 April 4th 23 10:28 AM
Calculate Percentage Based On Number GoodTrouble Excel Discussion (Misc queries) 8 February 8th 08 06:03 PM
SUMIF to calculate units sold in a specified timeframe Nan Excel Worksheet Functions 5 December 17th 07 10:01 PM
Calculate percentage of time period Ricardo Monteiro :^) Excel Worksheet Functions 4 January 6th 06 02:46 PM
Calculate number based on percentage [email protected] Excel Worksheet Functions 12 October 26th 05 01:49 AM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"