If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculation Problem
I want to calculate production numbers
I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! |
#2
|
|||
|
|||
Calculation Problem
if the time duration in I5 is in hours, in J5 enter this:
=F5/I5 "Norm" wrote: I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! |
#3
|
|||
|
|||
Calculation Problem
The average per hour would be F5/I5 but where does the "standard number" in
G2 come in. What is it? How does it effect your calculation? -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Norm" wrote: I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! |
#4
|
|||
|
|||
Calculation Problem
I had production of 37 pieces done in 37 minutes
I need to know what that equals in 60 min I can not get J5 to show 60 pieces per hour F5 is a number and I5 is time Thank you for your help "dlw" wrote: if the time duration in I5 is in hours, in J5 enter this: =F5/I5 "Norm" wrote: I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! |
#5
|
|||
|
|||
Calculation Problem
I had thought the the per hour target (in G2) would come into the calculation
When I use F5/I5 I get 1465 per hour which does not work if I had 37 pieces done in 37 minutes "Russell Dawson" wrote: The average per hour would be F5/I5 but where does the "standard number" in G2 come in. What is it? How does it effect your calculation? -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Norm" wrote: I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! |
#6
|
|||
|
|||
Calculation Problem
=F5/I5*60
Duration is in minutes -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Norm" wrote: I had thought the the per hour target (in G2) would come into the calculation When I use F5/I5 I get 1465 per hour which does not work if I had 37 pieces done in 37 minutes "Russell Dawson" wrote: The average per hour would be F5/I5 but where does the "standard number" in G2 come in. What is it? How does it effect your calculation? -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Norm" wrote: I want to calculate production numbers I have the standard number in G2 I have the actual production number in F5 I have the time duration in I5 I need the average per hour in J5 Can someone help please If more info is required please let me know Cheers!!! |
Thread Tools | |
Display Modes | |
|
|