| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculation problem | Excel Worksheet Functions | |||
| Calculation Problem | Excel Discussion (Misc queries) | |||
| Calculation problem? | Excel Discussion (Misc queries) | |||
| Calculation Problem | Excel Discussion (Misc queries) | |||
| Calculation Problem | Excel Discussion (Misc queries) | |||
Linear Mode
