# Items per hour?

#### K-R-Hattie

##### New Member
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?

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### Andrew Poulsom

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

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

#### buxtongt

##### Well-known Member
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

##### New Member
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

##### MrExcel MVP
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.

#### Andrew Poulsom

##### MrExcel MVP
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.

Replies
3
Views
292
Replies
3
Views
135
Replies
5
Views
124
Replies
41
Views
703
Replies
12
Views
448

1,195,664
Messages
6,011,015
Members
441,579
Latest member
satishrazdhan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back