Results 1 to 7 of 7

Calculate transactions per second

This is a discussion on Calculate transactions per second within the Excel Questions forums, part of the Question Forums category; I have a ordered column with the times that messages were sent. I need to count the number of times ...

  1. #1
    New Member
    Join Date
    Sep 2005
    Posts
    8

    Default Calculate transactions per second

    I have a ordered column with the times that messages were sent. I need to count the number of times the time is the same (to get transactions per second).

    example:
    3:53:22
    3:53:22
    5:41:45
    5:41:45
    5:43:45
    5:43:45
    6:00:34
    6:00:34
    6:04:23
    6:04:23
    6:04:23
    6:04:23
    6:04:24
    6:04:24
    6:04:24
    6:04:24

  2. #2
    Board Regular schielrn's Avatar
    Join Date
    Apr 2007
    Location
    Cincinnati, Ohio
    Posts
    6,924

    Default Re: Calculate transactions per second

    Could you possibly explain what you expect for results? Are you wanting to average together all the individual times to see an overall average?

    Based on how I calculated it I got an average of 2.67 transactions per second?

    Is your data set much larger than this example?
    Always make a back up copy before trying new code, you never know what you might lose!


    - Posting guidelines, forum rules and terms of use

    -Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    "The world suffers a lot. Not because of the violence of bad people, but because of the silence of good people!"

  3. #3
    New Member
    Join Date
    Sep 2005
    Posts
    8

    Default Re: Calculate transactions per second

    For each time, I need the number of transactions that took place. There were 2 transactions for the first time, 4 transactions for the second time, 2 transactions for the third time, etc. I am looking for the count instead of the average. The example below is a sample of over 6000 entries. Ultimately, I want to create a line graph that displays two lines that compares the tps between 2 different days. The time would represent the x axis and the count would represent the y axis.

  4. #4
    Board Regular schielrn's Avatar
    Join Date
    Apr 2007
    Location
    Cincinnati, Ohio
    Posts
    6,924

    Default Re: Calculate transactions per second

    Can you use advance filter to pull out the unique times and then use a countif formula:

    =countif(A:A,B1)

    Where column A has the times and B1 contains the time you are wanting a count of?
    Always make a back up copy before trying new code, you never know what you might lose!


    - Posting guidelines, forum rules and terms of use

    -Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    "The world suffers a lot. Not because of the violence of bad people, but because of the silence of good people!"

  5. #5
    New Member
    Join Date
    Sep 2005
    Posts
    8

    Default Re: Calculate transactions per second

    How would I get a count for each time if I pull out unique times?

  6. #6
    Board Regular schielrn's Avatar
    Join Date
    Apr 2007
    Location
    Cincinnati, Ohio
    Posts
    6,924

    Default Re: Calculate transactions per second

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: 11.0 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    1
    Times  Times 
    2
    3:53:22  3:53:222
    3
    3:53:22  5:41:452
    4
    5:41:45  5:43:452
    5
    5:41:45  6:00:342
    6
    5:43:45  6:04:234
    7
    5:43:45  6:04:244
    8
    6:00:34    
    9
    6:00:34    
    10
    6:04:23    
    11
    6:04:23    
    12
    6:04:23    
    13
    6:04:23    
    14
    6:04:24    
    15
    6:04:24    
    16
    6:04:24    
    17
    6:04:24    
    Sheet1 

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
    Always make a back up copy before trying new code, you never know what you might lose!


    - Posting guidelines, forum rules and terms of use

    -Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    "The world suffers a lot. Not because of the violence of bad people, but because of the silence of good people!"

  7. #7
    New Member
    Join Date
    Sep 2005
    Posts
    8

    Default Re: Calculate transactions per second

    That's it! Thanks lots.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com