Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record count divided by time? (Excel 97)

    Need to find out how to get some kind of time/number. Transaction 1 - transfered 293,042 records in 2:34:04 (hh:mm:ss) how do I find out how many records per min.? or by sec.?

    Thank you

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record count divided by time? (Excel 97)

    Daniel:
    supposing that the amount of transferred data is in A1 and the time in B1.

    Put the formula in C1 :
    =A1/(((HOUR(B1)*60)*60)+MINUTE(B1)*60+SECOND(B1))

    C1 must be in General format

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record count divided by time? (Excel 97)

    =A1/(B1*86400)

    where houses a value like 293,042 and B1 a time value like 2:34:04 (hh:mm:ss).

    The formula computes records per second.

    Format the formula cell as General.

    Aladin
    Microsoft MVP - Excel

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record count divided by time? (Excel 97)

    Now that I have the format... btw, thanks to everyone. I need to chart this information. I need to see if I can crate a chart with the following info. on 1 chart.
    1. number of recrods (234,432) 2. # per hour(1,234) 3. # per min(432) 4. # per sec. (3) This is just an example and not real data.

    How can I show 1 and 3 on the same chart? The number from 1 is so big that the number from 3 will hardly register at the bottom of the line. Is there a way to show a line at the bottom to show option 3 and then at the top to show option1?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Record count divided by time? (Excel 97)

    An Excel chart can have two value axes (y-axes). Select one of the series, select Format/Selected Series..., Axis tab, and click Secondary Axis.
    Now you will have a value axis on either side of the chart. You can let Excel set the scale properties automatically, or set them yourself for each axis separately.

Posting Permissions

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