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 |