Help with period between two dates based on category

[João_Santos]

Hello!

I need a really specific Measure / calculated field that indicates the amount of time inside a factory by considering the Date and the type of entry and then convert to HOURS

Name	Acess	Date	Hour	Desired Result 1 Period	Desired Result 2 Hours
JOAO	In	05/07/2023	09:20	0,00	0:00
JOAO	Out	05/07/2023	10:30	1,17	1:10
JOAO	In	05/07/2023	10:40	-0,17	-0:10
JOAO	Out	05/07/2023	17:19	6,65	6:39
PEDRO	In	06/07/2023	15:21	0,00	0:00
PEDRO	Out	06/07/2023	15:38	0,28	0:17