Your numbers would appear to be correct. I looked at the ratios between B
and A and D and C and they are both close, since those ratios are close
(Fld/FL = 9.888495 and Fld Itms/Fl Itms = 9.888539) If your counts and
elapsed times are correct, then you've done the math right. I presume the
29: and 292: values are hours? Right?

Is there any other reason you would expect the rate per hour to fluctuate
greatly over either a short or a long period of time - such as having
shut-down times for maintenance or such?

"tryn''''2learn" wrote:

Good afternoon,

I am having a problem when it comes to getting a total of items per hour
here is an example:
A B C D E F
FL Fld Fl Itms Fld Itms Fl Per Hr Fld Per Hr
39,496 390,556 29:33:34 292:17:59 1,336.16 1336.149063

in columns E & F are where I am using the formula
in column E: =A3/C3/24 and I'm getting the total 1,336 and it should be
between around 300-500 items
in column F: =B3/D3/24 and I'm getting the total 1336 and this actually is
about right. my concern is I'm getting the same total for both fields.

I appreciate your help.