HOW TO COUNT UNIQUE ACC LESS THAN OR EQUAL 1 HOUR PER MONTH

[AYSHANA]

DEAR ALL
GOOD DAY
HOPE DOING WELL
I WOULD LIKE TO ASK HOW CAN I GET HOW MANY UNIQUE ACC WAS ALLOCATED WITHIN LESS THAN OR EQUAL ONE HOUR PER MONTH.

I HAVE TRIED TO USE IF AND VLOOKUP FUNCTIONS BUT IT DIDN'T WORK.

APPRECIATE THE HELP

TIMEEE.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	ACC no.	R Date Time	UNIT NUMBER Allocated	UNIT ALLOCATED IN SYSTEM	TIME DIFFERENCE		EXPECTED RESULT
2	M393108	06-03-23 13:07	111	06-03-23 13:07	0:00		MAR	APR	MAY	JUN	JUL
3	M393108	06-03-23 13:07	122	06-03-23 13:07	0:00		1	0	1	0	0
4	W101107	05-07-23 19:57	133	05-07-23 21:13	1:16
5	W101107	05-07-23 19:57	144	05-07-23 21:13	1:16
6	F490690	31-03-23 18:14	1555	31-03-23 21:05	2:51
7	F490690	31-03-23 18:14	1666	31-03-23 21:05	2:51
8	W766983	24-05-23 6:09	1777	24-05-23 6:43	0:34
9	W766983	24-05-23 6:09	1888	24-05-23 6:43	0:34
10	H562691	30-03-23 18:40	1999	30-03-23 23:00	4:20
Sheet1

Cell Formulas
Range	Formula
E2:E10	E2	=D2-B2

 

[AYSHANA]

ANYONE

 

[AYSHANA]

hi again,

I was able to get how many unique acc i have per month

now i would like to count how many from the unique acc is greater than 2 hours based on the time difference
and how many unique acc are less than 2 hours based on the time difference

if anyone can help me with the formula
thank you.

TIMEEE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	ACC no.	CID	Result Date Time	UNIT NUMBER Allocated in BGRPS order	UNIT ALLOCATED IN SYSTEM	TIME DIFFERENCE		UNIQUE ACC PER MONTH
2	W601811	L3630509712	29-03-23 8:27	U240123013059	29-03-23 13:16	4:49		MAR	APR	MAY	JUN	JUL
3	W601811	L3630509712	29-03-23 8:27	U240123009694	29-03-23 12:53	4:26		96	100	106	108	121
4	W602186	L3630510475	29-03-23 9:30	U240123013663	29-03-23 15:45	6:15
5	F490690	L3630557131	31-03-23 18:14	U240123012382	01-04-23 9:37	15:23	HOW MANY FROM THE UNIQUE ACC IS GRATER THAN 2 HOURS BASED ON TIME DIIFFERENCE
6	F490690	L3630557131	31-03-23 18:14	U240123011238	31-03-23 21:05	2:51		MAR	APR	MAY	JUN	JUL
7	F490690	L3630557131	31-03-23 18:14	U240123010572	31-03-23 21:05	2:51
8	H559110	L3630540258	30-03-23 14:22	U240123014248	30-03-23 17:34	3:12
9	H559110	L3630540258	30-03-23 14:22	U240123013150	30-03-23 15:55	1:33	HOW MANY FROM THE UNIQUE ACC IS LESS THAN 2 HOURS BASED ON TIME DIFFERENCE
10	H562691	L3630543991	30-03-23 18:40	U240123011182	30-03-23 23:00	4:20		MAR	APR	MAY	JUN	JUL
11	M459275	L3630467555	27-03-23 5:23	U240123011586	28-03-23 13:20	7:57
12	M459275	L3630467555	27-03-23 5:23	U240123012513	28-03-23 13:14	7:51
13	M459275	L3630467555	27-03-23 5:23	U240123012008	27-03-23 12:37	7:14
14	M459275	L3630467555	27-03-23 5:23	U240123012429	27-03-23 7:58	2:35
15	X382761	L3640010160	02-04-23 15:00	U240123013356	02-04-23 15:20	0:20
16	S504592	L3640005106	01-04-23 16:29	U240123010273	02-04-23 5:00	12:31
17	S504592	L3640005106	01-04-23 16:29	U240123010121	02-04-23 1:10	8:41
18	S504592	L3640005106	01-04-23 16:29	U240123012319	01-04-23 20:51	4:22
19	M458621	L3630466734	27-03-23 3:29	U240123008997	27-03-23 4:19	0:50
20	M458621	L3630466734	27-03-23 3:29	U240123008998	27-03-23 4:19	0:50
Sheet2

Cell Formulas
Range	Formula
H3	H3	=ROUNDUP(SUM(IFERROR(1/(COUNTIF($A$2:$A$2005,$A$2:$A$2005)*(TEXT($E$2:$E$2005,"mmm")=$H2)),0)),0)
I3	I3	=ROUNDUP(SUM(IFERROR(1/(COUNTIF($A$2:$A$2005,$A$2:$A$2005)*(TEXT($E$2:$E$2005,"mmm")=$I2)),0)),0)
J3	J3	=ROUNDUP(SUM(IFERROR(1/(COUNTIF($A$2:$A$2005,$A$2:$A$2005)*(TEXT($E$2:$E$2005,"mmm")=$J2)),0)),0)
K3	K3	=ROUNDUP(SUM(IFERROR(1/(COUNTIF($A$2:$A$2005,$A$2:$A$2005)*(TEXT($E$2:$E$2005,"mmm")=$K2)),0)),0)
L3	L3	=ROUNDUP(SUM(IFERROR(1/(COUNTIF($A$2:$A$2005,$A$2:$A$2005)*(TEXT($E$2:$E$2005,"mmm")=$L2)),0)),0)
F2:F20	F2	=E2-C2
Press CTRL+SHIFT+ENTER to enter array formulas.