# Thread: Records per min. (Excel 2k)

1. ## Records per min. (Excel 2k)

I need to find out if I do 190,391,897 records for 6 months and it too a total 833.34 min to do this. What is the average number of records per min. Can anyone tell how to figure out this formual.

Thanks

2. ## Re: Records per min. (Excel 2k)

If the number of records is in cell A1 and the number of minutes in cell A2, the average number of records per minute can be calculated with the formula =A1/A2, but this is probably too naive. Do the 6 months come into the calculation somewhere, and if so, how?

3. ## Re: Records per min. (Excel 2k)

How are the minutes entered into the worksheet? Is it a decimal number 833.34, or is it an Excel time value?

If the number of records is in A1, and the time is in A2, and the time is entered as a decimal number, then the formula would be:

<pre>=A1/A2
</pre>

If the time is entered as an Excel time value, then the formula would be:

<pre>=A1/(A2*1440)
</pre>

The 1440 is the number of minutes in a day.

4. ## Re: Records per min. (Excel 2k)

In this case cell A1 has number of records 894345, and cell B1 time 00:03:32 (hh:mm:ss). It goes from A1 down to A8000 and B8000.
at A8001 the total is 43,435,654 with B8002 as 04:34:41 (hh:mm:ss). Now we want to see how many records we do per miniute. The totals are from using the Sum function.
=Sum(A1:A8000)

5. ## Re: Records per min. (Excel 2k)

With that many rows, you should probably use [hh]:mm:ss as time format - this allows for hours above 24.

To calculate the number of records per minute, use Legare Coleman's second formula - you must multiply a time value by 24 * 60 = 1440 to convert to minutes: = A8001/(B8002*1440) (shouldn't that be B8001?)

6. ## Re: Records per min. (Excel 2k)

Legare's formula is what you want.
<pre>=A1 / (B1 * 1440)</pre>

or equivalently:
<pre>=A1 / B1 / 1440</pre>

Excel datesare numerically in DAYS hence the conversion.

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•