|
| 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
May 15th, 2009, 02:53 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
May 15th, 2009, 04:35 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 15th, 2009, 04:40 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
