Calculate Lines per Hour

**AlpacaMama** · 03-11-2010, 05:26 PM

I looked around the internet to solve my formula problem but I get results on the basic formula that does not work for me. I am using Excel 2007.

I have a column that holds # of minutes (B2) and another column that holds # of lines (C2). I want to know how many lines per minutes.

The simple formula of =(C2*60)/B2 does not work because of the way I gather my data in column B and C.

Column B has this formula =SUMIF(Hours!A:A,$A2,Hours!D:D)
Column C has this formula =SUMIF(Data!C:C,$A2,Data!D:D)

So, I am unfortunately not getting my data directly from one cell such as the basic formula requires. I am computing it to only sum if the date is equal to the one in column A. Because my data involves minutes/formatting the result of 77 lines in 180 minutes is 36960.00 instead of 25.67 lines per hour.

I tried various formatting and can never get it to show 25.67. What am I missing?

**teylyn** · 03-11-2010, 05:48 PM

Hi AlpacaMama, welcome to the forum.

This will be easier to understand and solve if you can post a data sample. You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

**AlpacaMama** · 03-11-2010, 07:27 PM

Here is my file attached. Having issues with cell D2 on the Prod-Hour sheet.

**teylyn** · 03-11-2010, 08:16 PM

You can change your formula in column B to

=SUMIF(Hours!A:A,$A2,Hours!D:D)*60*24

and format the result as General. This will then truly be the number of minutes as a value.

Or you can use this in column D

=(C2*60)/(B2*60*24)