MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
  `date` TIME,
  areaName VARCHAR(10),
  `node_address/person` INT
  );
INSERT INTO test VALUES
('8:15',	'area1',	1),
('8:20',	'area1',	1),
('8:25',	'area1',	1),
('8:30',	'area1',	1),
('8:45',	'area1',	1),
('9:00',	'area1',	1),
('8:15',	'area2',	2),
('8:20',	'area2',	2),
('9:00',	'area2',	1),
('9:05',	'area2',	2),
('9:10',	'area2',	2);

Records: 11  Duplicates: 0  Warnings: 0


SELECT *, ROW_NUMBER() OVER (PARTITION BY `node_address/person` ORDER BY `date`) rn
FROM test;


date
areaName
node_address/person
rn


08:15:00
area1
1
1

08:20:00
area1
1
2

08:25:00
area1
1
3

08:30:00
area1
1
4

08:45:00
area1
1
5

09:00:00
area1
1
6

09:00:00
area2
1
7

08:15:00
area2
2
1

08:20:00
area2
2
2

09:05:00
area2
2
3

09:10:00
area2
2
4


WITH 
cte AS (
  SELECT *, 
         (ROW_NUMBER() OVER (PARTITION BY `node_address/person` ORDER BY `date`) - 1) DIV 2 rn
  FROM test
  )
SELECT areaName, `node_address/person`,
       MIN(`date`) date_in, MAX(`date`) date_out
FROM cte
GROUP BY areaName, `node_address/person`, rn;


areaName
node_address/person
date_in
date_out


area1
1
08:15:00
08:20:00

area1
1
08:25:00
08:30:00

area1
1
08:45:00
09:00:00

area2
1
09:00:00
09:00:00

area2
2
08:15:00
08:20:00

area2
2
09:05:00
09:10:00


WITH 
cte1 AS (
  SELECT *, 
         (ROW_NUMBER() OVER (PARTITION BY `node_address/person` ORDER BY `date`) - 1) DIV 2 rn
  FROM test
  ),
cte2 AS (
  SELECT areaName, `node_address/person`,
         MIN(`date`) date_in, MAX(`date`) date_out
  FROM cte1
  GROUP BY areaName, `node_address/person`, rn
  )
SELECT areaName, SEC_TO_TIME(SUM(TIME_TO_SEC(date_out) - TIME_TO_SEC(date_in))) total
FROM cte2
GROUP BY areaName;


areaName
total


area1
00:25:00

area2
00:10:00

date	areaName	node_address/person	rn
08:15:00	area1	1	1
08:20:00	area1	1	2
08:25:00	area1	1	3
08:30:00	area1	1	4
08:45:00	area1	1	5
09:00:00	area1	1	6
09:00:00	area2	1	7
08:15:00	area2	2	1
08:20:00	area2	2	2
09:05:00	area2	2	3
09:10:00	area2	2	4