Google Sheets: Filter Multiple Login and Logout

Hi guys. Hopefully you could help me complete what I want to achieve.

I have 3 columns A:C

A = Employee Name
B = Timestamp (Date&Time)
C = In/Out

Example:
Agent 1 | 12/15/20 4 AM | Login
Agent 1 | 12/15/20 5 AM | LogOut
Agent 1 | 12/15/20 6 AM | Login
Agent 1 | 12/15/20 7 AM | LogOut
Agent 1 | 12/15/20 8 AM | LogIn

I want to create a filter for columns D:E

D = First Login, Second Login, Third Login
E = First Logout, Second Logout, Third Login

the main Idea is I'm looking for their Logouts followed by their next Login. This would help with computing Unproductive Hours (Duration between Logout and next login).

Attachment 709127

This is what I'm trying to achieve.

I'm currently using Google Sheet and it shows as blank on my end. Is there some code that we could have used/modify?

It's alright. I think I've got it now.

The data shows if I made it an Array Formula.

Thanks a lot! How can I mark this thread as solved?

Originally Posted by bebo021999

Array formula? No, I don't think so. Just confirm formula input by "Enter" only.

What if there's a lot of agent? Will it be the same thing?

Example:
Agent 1
Agent 2
Agent 2
Agent 3
Agent 1
Agent 3
Agent 2

Will it be the same code?