Good morning,
i've got a table like this:
AREA ,USER, TIME,
1, A,18/02/2023 10:05:00,
2, A,18/02/2023 18:04:00,
1, C,18/02/2023 12:05:00,
2, C,18/02/2023 19:04:00,
3, B,20/02/2023 ,05:00:00,
4, B,20/02/2023 09:10:10.
I would like to get for every user on the same day the time in minutes (given like difference between the two data).
For example:
user A --> 18/02/2023 -->result: 08:01
Thanks
C.
