Per hour help please

[Guest]

I’m trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula I’m getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I’m getting the same total 1,336 for my per hour: (Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process flats
over folds.
Flats are a package type that contain 6 pages average… 6 pages = 1 package
Folds are also a package type that contains 25 pages average… 25 pages = 1
package

 

[David Biddulph]

It doesn't look as if the problem is with your formula, so perhaps your data
values are wrong?

 

[Guest]

thank you, I will recheck the data source... I'm starting to think I just
don't have enough information.

co-worker just informed me that numbers are pulled off the machine and
printed so the data is accurate. thank you for your help anyway.

 

[M. Authement]

Are you using absolute references? Is the workbook in manual calculation
mode and needs to be calculated? It seems odd that you would get the exact
same result for two different data sets.

 

[Guest]

Yes the numbers are valid. I must confess I don't understand what you mean
by manual calculation?

 

[Guest]

try punching the F9 Function Key to do a re-calculate. Under your
Options>General check for auto recalc

 

[M. Authement]

Just to clarify...I was not questioning the validity of the data. In the
formula that you use to calculate per hour, do the cell references have $
next to the column letter or row number? Did you create the formula for the
first set of data and then copy/paste it for the second set? If so, and if
there are $ (absolute references), then that would explain why the results
are the same for the two different data sets.

See Reno's response regarding the manual calculation.