If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|