Summarizes employee access data or records per day.

[numfon_naka]

I made an app to record employee toilet visits. I would like to summarize information such as

AS Supervisor has 36 employees.
One employee will have the right to record 6 toilet visits/day, but more than that is abnormal.
36 * 6 = 216 times a day

and i want to know How many times does this person go to the bathroom each day?

Summarizing information for each person and each day

Date	Code Employee	Name	Ttime to go to the bathroom	Time back from the bathroom	Period	Supervisor
วันที่	รหัสพนักงาน	ชื่อ-สกุล	เวลาออกไลน์	เวลาเข้าไลน์	ระยะเวลา	หัวหน้างาน
21/10/2022	12345	A	10:00	10:30	0:30:00	AS
21/10/2022	6789	B	11:20	11:40	0:20:00	QA
21/10/2022	12345	A	13:20	13:50	0:30:00	AS
22/10/2022	12345	A	8:00	8:30	0:30:00	AS
22/10/2022	6789	B	11:30	12:45	1:15:00	QA

[numfon_naka]

desired example

Date	Supervisor	Name	Ttime to go to the bathroom	Time back from the bathroom	Period	Supervisor	All used
21/10/2022	AS
		A	10:00	10:30	0:30:00	AS	2
		A	13:20	13:50	0:30:00	AS