<style type="text/css"> @Page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 115% } </style>I have 2 columns ofdata, the First is a list of Times in HH:MM:SS format and the SecondWeb sites visited, I need a formula that reads the time columnminutes and counts the number of web sites visited per minute thensums them below the last visit in that minute and does the same thingin the next minute etc.
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Web site Address
[/TD]
[/TR]
[TR]
[TD]10:20:00
[/TD]
[TD]https://www.bbc.co.uk[/TD]
[/TR]
[TR]
[TD]10:20:45[/TD]
[TD]www.msn.com/en-gb
[/TD]
[/TR]
[TR]
[TD]No. of visits per minute = 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10:21:15[/TD]
[TD]https://www.mrexcel.com/forum/index.php
[/TD]
[/TR]
[TR]
[TD]10:21:17[/TD]
[TD]https://www.quora.com
[/TD]
[/TR]
[TR]
[TD]10:21:18[/TD]
[TD]https://www.youtube.com/?gl=GB&hl=en-GB
[/TD]
[/TR]
[TR]
[TD]10:21:20[/TD]
[TD]https://www.bbc.co.uk[/TD]
[/TR]
[TR]
[TD]No. of visits per minute = 4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks for yourhelp!
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Web site Address
[/TD]
[/TR]
[TR]
[TD]10:20:00
[/TD]
[TD]https://www.bbc.co.uk[/TD]
[/TR]
[TR]
[TD]10:20:45[/TD]
[TD]www.msn.com/en-gb
[/TD]
[/TR]
[TR]
[TD]No. of visits per minute = 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10:21:15[/TD]
[TD]https://www.mrexcel.com/forum/index.php
[/TD]
[/TR]
[TR]
[TD]10:21:17[/TD]
[TD]https://www.quora.com
[/TD]
[/TR]
[TR]
[TD]10:21:18[/TD]
[TD]https://www.youtube.com/?gl=GB&hl=en-GB
[/TD]
[/TR]
[TR]
[TD]10:21:20[/TD]
[TD]https://www.bbc.co.uk[/TD]
[/TR]
[TR]
[TD]No. of visits per minute = 4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks for yourhelp!