Items per hour?

[K-R-Hattie]

Hi,
I am trying to calculate how many items pack in an hour, my spread sheet is set out like so:

Shift Date Cast Time Nº of packs Length Weight P,P,Hour
A 03.11.2011 12345 11:05 1 6m 5.38 -
A 03.11.2011 12345 11:25 1 6m 5.38 -
A 03.11.2011 12345 12:00 1 6m 5.38 -
B 03.11.2011 14895 12:10 1 6m 5.38 -

When the hour changes the packs per hour (p,P,Hour) column calculates how many items have been packed in that hour and returns the result.

I do not have a clue were to even start with this. Can any one point me in the right direction?

 

[Andrew Poulsom]

Where are the start and finish times? Packs per hour is:

=Nº of packs/(Time taken*24)

 

[buxtongt]

Can you explain the math used to get that 5.38 number? I'm assuming that is the one you want to be calculated when some other value changes.

 

[K-R-Hattie]

Hi Thanks for having a look,

The time is in column D, this is entered in using a user form and is Time().
Each time a items is packed the operator enters in all of the details in the user form at which point the Time() time is entered in to Column D this is on going through out a 24 hour period. What I am trying to do is each time a complete hour has lapsed Column H will look at D and work out the count in Column E giving me the total number of items packed in the hour.

Each entry gives the Time() at the time of the entry using VBA.
At the end of a 24 hour period there will be 24 totals 1 for each hour.

I hope this makes sense.

 

[Andrew Poulsom]

Can you explain the math used to get that 5.38 number? I'm assuming that is the one you want to be calculated when some other value changes.

That's the Weight.

 

[buxtongt]

That's the Weight.

No wonder it didn't make any sense at all.

 

[Andrew Poulsom]

For the last entry in your sample data the packs per hour would be:

=SUM(E3:E5)/((D5-D2)*24)

which returns 2.77. But you are missing a start time for the first entry.