Hi ,

I've a requirment to count the concurrent connections to a website for every minute,hour or day..

My data will look like this...

Service 
No	Start Date Time		Completion Date Time	Requested Url

1	25/12/2006 00:03:03	25/12/2006 00:05:32	www.google.com.au	
2	25/12/2006 00:03:12	25/12/2006 00:05:31	www.google.com.au	
3	25/12/2006 00:21:41	25/12/2006 00:24:10	www.google.com.au	
4	25/12/2006 00:31:15	25/12/2006 00:33:39	www.google.com.au	
5	25/12/2006 00:36:11	25/12/2006 00:38:40	www.google.com.au	
6	25/12/2006 00:46:19	25/12/2006 00:48:48	www.google.com.au	
7	25/12/2006 01:01:22	25/12/2006 01:03:51	www.google.com.au	
8	25/12/2006 01:15:12	25/12/2006 01:17:41	www.google.com.au	
9	25/12/2006 01:22:41	25/12/2006 01:25:10	www.google.com.au	
10	25/12/2006 01:32:05	25/12/2006 01:33:23	www.google.com.au	
11	25/12/2006 01:52:32	25/12/2006 01:55:06	www.google.com.au	
12	25/12/2006 01:52:41	25/12/2006 01:55:10	www.google.com.au

If you can see the first 2 rows...service no 1  and 2 ...they have connected to the URl Google.com. almost at the same time..

My requirment is to count the concurrent connections for every minute  i.e i should spreadout each connection time for 
every minute


 Service no   00  01  02  03  04  05  06 				Count 
 1	                   ----------	  Full 1 minute from 04 to 05  	1

 2	                    ---------	  Full 1 minute from 04 to 05	1


I hope i'm clear with my requirment
Thanks a ton.