# Transaction per minute

1. ## Transaction per minute

This is for stock market, I want to know for every minutes how many transactions happen. Many transactions can happen into 1 minute.
For evey "time" that appear = 1 transaction. I insert a picture of my spreadsheet.
So I want to know how many transaction/minute. Then later show it in a graph.

Exemple here at 9:30, there was 23 transactions.

For 9:31, there was 6 transactions. So

1 at 09:31:54
1 at 09:31:36
1 at 09:31:33
1 at 09:31:27
1 at 09:31:24
1 at 09:31:24

Time
09:35:09
09:34:51
09:34:51
09:34:48
09:34:48
09:34:48
09:34:48
09:34:42
09:34:30
09:34:27
09:33:57
09:33:48
09:33:42
09:32:21
09:32:21
09:32:15
09:31:54
09:31:36
09:31:33
09:31:27
09:31:24
09:31:24
09:30:57
09:30:36
09:30:36
09:30:33
09:30:33
09:30:33
09:30:33
09:30:30
09:30:30
09:30:30
09:30:30
09:30:30
09:30:27
09:30:21
09:30:18
09:30:15
09:30:03
09:30:03
09:30:03
09:30:03
09:30:00
09:30:00
09:30:00

2. Put this formula in B2

=FLOOR(A2,1/(24*60)) format to TIME and auto-fill down the column to cell B46

Then select B2:B46 right click, Copy > Paste special > Value, format to TIME. Delete column B.

With B2:B46 selected, go to Data > Filter > Advanced Filter, select "Copy to another location", in the "Copy to", click cell D2, then select "Unique records only".

You should now have TIMES listed in cells C2:C7

In cell D2, put this formula and drag down to C7

=COUNTIF(\$B\$2:\$B\$46,C2)

Results should be 1,9,3,3,6 and 23

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1