Count number of times event happens.

[Tspears1]

Not sure if this is possible, but I thought would ask. In the below example I need to find out how many times a Tech left a call and then in less than 30 minutes later, that line called again. For example on 10/22/2024 Tech B left line 1 at 1012(military time) and line 1 called again at 1030. This will add 1 to Tech B total. So in this example Tech A = 1, Tech B = 4, Tech C = 2.

Any help with this would be greatly appreciated. I have a very large spreadsheet that I would like to extract this information from.

LINE	DATE	CALL TIME	OUT TIME	TECH
1	10/22/2024	823	845	A
1	10/22/2024	955	1012	B
2	10/22/2024	1030	1035	C
3	10/22/2024	830	840	C
1	10/22/2024	1030	1055	A
2	10/22/2024	1045	1115	A
2	10/23/2024	1425	1450	B
3	10/23/2024	1255	1310	B
2	10/23/2024	1510	1530	C
3	10/23/2024	1330	1345	A
2	10/23/2024	1545	1650	A
1	10/24/2024	750	830	C
1	10/24/2024	910	930	B
3	10/24/2024	820	835	A
3	10/24/2024	850	920	A
1	10/24/2024	955	1020	B

 

[Tspears1]

YES!, This worked. Thank you very much.

 

[SanjayGMusafir]

Glad again to help you and thanks for the feedback.