Calculation Problem

  • Thread starter Thread starter Norm
  • Start date Start date
N

Norm

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!!!
 
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
 
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
 
Back
Top