Prev: How to take information from one work sheet to another?
Next: How to delete digital signature certificate?
From: Russell Dawson on 15 Apr 2010 23:37
=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!!!
First  |  Prev  | 
Pages: 1 2
Prev: How to take information from one work sheet to another?
Next: How to delete digital signature certificate?