ExcelBanter - Calculate Items Per Hour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculate Items Per Hour (https://www.excelbanter.com/excel-discussion-misc-queries/230912-calculate-items-per-hour.html)

karthik

Calculate Items Per Hour

Hi,
I've items Produced in Column A and the time taken to produce in Column B, I
would like to know if there is a way to calculate number of items produced in
an hour.
Data looks like this.

A B
15 0:02:01
20 0:03:36
169 0:15:45
742 1:08:55
535 0:15:56
52 0:03:14

Time is in HH:MM:SS format.
Thanks for your help in advance.

--
Karthi

Jacob Skaria

Calculate Items Per Hour

=SUM(A1:A10)/SUM(B1:B10)/24

If this post helps click Yes
---------------
Jacob Skaria

"Karthik" wrote:

Hi,
I've items Produced in Column A and the time taken to produce in Column B, I
would like to know if there is a way to calculate number of items produced in
an hour.
Data looks like this.

A B
15 0:02:01
20 0:03:36
169 0:15:45
742 1:08:55
535 0:15:56
52 0:03:14

Time is in HH:MM:SS format.
Thanks for your help in advance.

--
Karthi

Jacob Skaria

Calculate Items Per Hour

If these are different items use the below formula in Col C1 and copy that
down.

=A1/B1/24

Format C to Number with/without decimal places to suit your requirement

If this post helps click Yes
---------------
Jacob Skaria

"Karthik" wrote:

Hi,
I've items Produced in Column A and the time taken to produce in Column B, I
would like to know if there is a way to calculate number of items produced in
an hour.
Data looks like this.

A B
15 0:02:01
20 0:03:36
169 0:15:45
742 1:08:55
535 0:15:56
52 0:03:14

Time is in HH:MM:SS format.
Thanks for your help in advance.

--
Karthi

All times are GMT +1. The time now is 02:00 PM.