Calculate transactions per second

Thanks:  0
Likes:  0

# Thread: Calculate transactions per second

1. ## 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. ## 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?

3. ## 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. ## 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?

5. ## Re: Calculate transactions per second

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

6. ## 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
 E2E3E4E5E6E7 =

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.

7. ## Re: Calculate transactions per second

That's it! Thanks lots.

## User Tag List

#### Posting Permissions

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