MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Calculation Problem

• Follow

```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
Cheers!!!
```
 0

```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
> Cheers!!!
```
 0

```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

"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
> Cheers!!!
```
 0

```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

"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
> > Cheers!!!
```
 0

```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
>
>
>
> "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
> > Cheers!!!
```
 0

```=F5/I5*60
Duration is in minutes
--
Russell Dawson
Excel Student

"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
> >
> >
> >
> > "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
> > > Cheers!!!
```
 0

5 Replies
258 Views

Similiar Articles:

7/17/2012 12:47:16 PM