Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Pounds Per Hour | Excel Discussion (Misc queries) | |||
how do i calculate what i make in a year into an hour? | Excel Worksheet Functions | |||
Items per hour | Excel Discussion (Misc queries) | |||
Total Items Per Hour | Excel Discussion (Misc queries) | |||
Calculate rate per hour | Excel Discussion (Misc queries) |