Calculate transactions per second

[gorchr]

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]

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]

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]

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]

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

 

[schielrn]

Book1
	A	B	C	D	E
1	Times			Times
2	3:53:22			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			6:04:24	4
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

 

[gorchr]

That's it! Thanks lots.