Calculate transactions per second

**gorchr** · Feb 22nd, 2008, 01:36 PM

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

**schielrn** · Feb 22nd, 2008, 01:51 PM

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?

**gorchr** · Feb 22nd, 2008, 02:00 PM

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.

**schielrn** · Feb 22nd, 2008, 02:07 PM

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?

**gorchr** · Feb 22nd, 2008, 02:26 PM

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

**schielrn** · Feb 22nd, 2008, 02:28 PM

******** ******************** ************************************************************************>

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

2

3:53:22

2

3

3:53:22

5:41:45

2

4

5:41:45

5:43:45

2

5

5:41:45

6:00:34

2

6

5:43:45

6:04:23

4

7

5:43:45