How to Get Earliest Time In and Latest Time Out

Hi experts!

I am trying to solve this for quite some time. I have a workbook with two sheets. On the first sheet it is the raw data. The raw data contains the actual log-ins and log-outs of the agents. On the second sheet is the report. My problem is, there are agents that have multiple log-ins and log-outs during the day. What I wat do is that on my LILO sheet I would only have the earliest log-in time and the latest log-out time of each agent.

Hope you can help thank you!