SQL Server 2017

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

create table Cardholder (
  FTItemID int primary key identity(101,1), 
  FirstName varchar(30),
  LastName varchar(30)
);
create table ReportEvent (
  ReportEvent int primary key identity(1001,1),
  EventType int,
  EventClass int,
  CardholderID int,
  ArrivalTime datetime,
  CONSTRAINT FK_ReportEventCardholderID foreign key (CardholderID) references Cardholder(FTItemID)
);
insert into Cardholder (FirstName, LastName) values 
('Leeann', 'Adel Urban');
1 rows affected

insert into ReportEvent (EventClass, CardholderID, ArrivalTime, EventType) values
 (41, 101, '2018-10-01 05:43', 20001)
,(41, 101, '2018-10-01 10:00', 0)
,(41, 101, '2018-10-01 10:59', 20001)
,(41, 101, '2018-10-01 14:32', 0)
,(41, 101, '2018-10-02 05:42', 20001)
,(41, 101, '2018-10-02 14:33', 0)
;
6 rows affected

SELECT 
 CONCAT(holder.FirstName+' ', holder.LastName) AS employee,
 CAST(repev.ArrivalTime AS DATE) AS [date],
 CAST(SWITCHOFFSET(repev.ArrivalTime,'+02:00') AS TIME)  as [time],
 IIF(repev.EventType = 20001, 'ENTRY', 'EXIT') AS Action,
 (CASE WHEN repev.EventType = 20001
  THEN DATEDIFF(minute, LAG(repev.ArrivalTime) 
                        OVER (PARTITION BY repev.EventClass, repev.CardholderID, CAST(repev.ArrivalTime AS DATE) 
                              ORDER BY repev.ArrivalTime), repev.ArrivalTime)
  END) AS OutTime
FROM [ReportEvent] AS repev
LEFT JOIN [Cardholder] AS holder ON holder.FTItemID = repev.CardholderID
WHERE repev.EventClass = 41
  AND holder.FirstName LIKE 'Leeann%';


employee
date
time
Action
OutTime


Leeann Adel Urban
01/10/2018 00:00:00
07:43:00
ENTRY
null

Leeann Adel Urban
01/10/2018 00:00:00
12:00:00
EXIT
null

Leeann Adel Urban
01/10/2018 00:00:00
12:59:00
ENTRY
59

Leeann Adel Urban
01/10/2018 00:00:00
16:32:00
EXIT
null

Leeann Adel Urban
02/10/2018 00:00:00
07:42:00
ENTRY
null

Leeann Adel Urban
02/10/2018 00:00:00
16:33:00
EXIT
null

employee	date	time	Action	OutTime
Leeann Adel Urban	01/10/2018 00:00:00	07:43:00	ENTRY	null
Leeann Adel Urban	01/10/2018 00:00:00	12:00:00	EXIT	null
Leeann Adel Urban	01/10/2018 00:00:00	12:59:00	ENTRY	59
Leeann Adel Urban	01/10/2018 00:00:00	16:32:00	EXIT	null
Leeann Adel Urban	02/10/2018 00:00:00	07:42:00	ENTRY	null
Leeann Adel Urban	02/10/2018 00:00:00	16:33:00	EXIT	null