MySQL 5.5

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

CREATE TABLE `tbregistros`(
`idregistros` int NOT NULL AUTO_INCREMENT, 
`idempleado` int NOT NULL, 
`fechahorareg` datetime NOT NULL, 
`status` int(1) NOT NULL, PRIMARY KEY (`idregistros`) )
insert into  tbregistros (idempleado, fechahorareg, status)  
select idempleado, fechahorareg, status
from(
          select  1    idempleado , '2021-01-01 08:23:04'  fechahorareg     ,1  status
union all select  1		,			'2021-01-01 18:40:04'					,2
union all select  1		,			'2021-01-02 08:23:04'					,1
union all select  1		,			'2021-01-02 18:40:04'					,2

union all select  2    idempleado , '2021-01-03 08:23:04'  fechahorareg     ,1  status
union all select  2		,			'2021-01-03 18:40:04'					,2
union all select  2		,			'2021-01-04 08:23:04'					,1
union all select  2		,			'2021-01-04 18:40:04'					,2

)t;
select ent.idempleado, ent.fechahorareg HoraEntrada,  sal.fechahorareg HoraSalida
from
(
	select 
			 t1.idempleado, t1.fechahorareg, t1.status,
			(
				select COUNT(*) +1
				from tbregistros
				where idempleado = t1.idempleado
				and status = 1
				and idregistros < t1.idregistros
			)  intRow
		from tbregistros t1
		where status = 1
)ent
left join
(
	select 
			 t1.idempleado, t1.fechahorareg, t1.status,
			(
				select COUNT(*) +1
				from tbregistros
				where idempleado = t1.idempleado
				and status = 2
				and idregistros < t1.idregistros
			)  intRow
		from tbregistros t1
		where status = 2
)sal
on ent.intRow = sal.intRow and ent.idempleado = sal.idempleado


idempleado
HoraEntrada
HoraSalida


1
2021-01-01 08:23:04
2021-01-01 18:40:04

1
2021-01-02 08:23:04
2021-01-02 18:40:04

2
2021-01-03 08:23:04
2021-01-03 18:40:04

2
2021-01-04 08:23:04
2021-01-04 18:40:04

idempleado	HoraEntrada	HoraSalida
1	2021-01-01 08:23:04	2021-01-01 18:40:04
1	2021-01-02 08:23:04	2021-01-02 18:40:04
2	2021-01-03 08:23:04	2021-01-03 18:40:04
2	2021-01-04 08:23:04	2021-01-04 18:40:04