Count of row between two time

[#1]

Hi,

I have to count no of lines between two time slot:

Input data:

Line	Activity	Time
1	login	9:15AM
2	listArtifact	9:20AM
3	createArtifact	9:40AM
4	logout	10:00AM
5	login	10:30AM
6	listArtifact	10:40AM
7	createArtifact	10:410AM
8	logout	10:44AM
9	login	10:46AM
10	listArtifact	10:50AM
11	createArtifact	10:52AM
12	logout	10:55AM

Desired output:

TimeLine	No of lines
9:00AM-10:00AM	3
10:00AM-11:00AM	9

How to count it & i have to show it on Line Chart.

Thanks

[#2]

I think you should use about intervalmatch(). It should be something like this.

table1:
load * from inputdata
table2:
load * inline[
start, end
9.30, 9.59
10.00, 10.59
....
];
intervalmatch:
intervalmatch(time)
load start, end
resident table2;

after this use join() to join tables