Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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
  •