Group by timestamp Dates

[jumiprado]

Guys, hello

I have the following report from access system for the Staff and i need to make a control access application per day where i can sum total_hhmmss for each day and compare the field Total_hhmmss with the difference between date_entrance and date_exit for check if the report works properly.

name	total_hhmmss	date_entrance	date_exit
STAFF1	01:12:00	02/11/2018 16:25	02/11/2018 17:37
STAFF1	01:51:00	05/11/2018 16:10	05/11/2018 18:01
STAFF1	01:19:00	06/11/2018 16:08	06/11/2018 17:27
STAFF1	01:49:00	07/11/2018 16:04	07/11/2018 17:53
STAFF1	01:57:00	08/11/2018 16:08	08/11/2018 18:05
STAFF1	02:09:00	12/11/2018 16:07	12/11/2018 18:16
STAFF1	01:20:00	13/11/2018 16:26	13/11/2018 17:46
STAFF1	01:56:00	15/11/2018 16:10	15/11/2018 18:06
STAFF1	00:21:00	16/11/2018 16:05	16/11/2018 16:26
STAFF1	01:22:00	20/11/2018 16:04	20/11/2018 17:26
STAFF1	01:29:00	21/11/2018 16:13	21/11/2018 17:42
STAFF1	00:12:00	21/11/2018 17:42	21/11/2018 17:54
STAFF1	01:23:00	22/11/2018 16:09	22/11/2018 17:32
STAFF1	01:58:00	26/11/2018 16:08	26/11/2018 18:06
STAFF1	01:24:00	03/12/2018 16:26	03/12/2018 17:50

Thanks!

[MindaugasBacius]

Could you provide the preferred result from your row data?

Thank you

[jumiprado]

I need something like this:

name	date_entrance	date_exit	Date_Entrance2	Date_Exit2	total_hhmmss	Dif Between Timestamp
STAFF1	02/11/2018 16:25	02/11/2018 17:37	02/11/2018	02/11/2018	01:12:00	01:12:00
STAFF1	05/11/2018 16:10	05/11/2018 18:01	05/11/2018	05/11/2018	01:51:00	01:51:00
STAFF1	06/11/2018 16:08	06/11/2018 17:27	06/11/2018	06/11/2018	01:19:00	01:19:00
STAFF1	07/11/2018 16:04	07/11/2018 17:53	07/11/2018	07/11/2018	01:49:00	01:49:00
STAFF1	08/11/2018 16:08	08/11/2018 18:05	08/11/2018	08/11/2018	01:57:00	01:57:00
STAFF1	12/11/2018 16:07	12/11/2018 18:16	12/11/2018	12/11/2018	02:09:00	02:09:00
STAFF1	13/11/2018 16:26	13/11/2018 17:46	13/11/2018	13/11/2018	01:20:00	01:20:00
STAFF1	15/11/2018 16:10	15/11/2018 18:06	15/11/2018	15/11/2018	01:56:00	01:56:00
STAFF1	16/11/2018 16:05	16/11/2018 16:26	16/11/2018	16/11/2018	00:21:00	00:21:00
STAFF1	20/11/2018 16:04	20/11/2018 17:26	20/11/2018	20/11/2018	01:22:00	01:22:00
STAFF1	21/11/2018 16:13	21/11/2018 17:42	21/11/2018	21/11/2018	01:35:00	01:29:00
STAFF1	21/11/2018 17:42	21/11/2018 17:54	21/11/2018	21/11/2018	01:35:00	00:12:00
STAFF1	22/11/2018 16:09	22/11/2018 17:32	22/11/2018	22/11/2018	01:23:00	01:23:00
STAFF1	26/11/2018 16:08	26/11/2018 18:06	26/11/2018	26/11/2018	01:58:00	01:58:00
STAFF1	03/12/2018 16:26	03/12/2018 17:50	03/12/2018	03/12/2018	01:24:00	01:24:00

thanks!