Calculate Items Per Hour

K

Karthik

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.
 
J

Jacob Skaria

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

advice on rounding or ceilng a 24 hour time value 3
WCG Stats Friday 07 April 2023 2
WCG Stats Sunday 05 February 2023 3
Calculate Pounds Per Hour 3
Pls help for Simple Calculation 1
Graph standardized values 3
Calculating whether solution is in time or not 4
Caluclate Pounds Per Hour 1

Top