Login and Logout Report

Good day,

I need assistance in login logout report. I have attached the file "login_logout".

As you can see on the file, there are two (2) sheets "raw data" and "schedule". On sheet "raw data", it contains the raw data of login and logout of our agents that I have extracted from CMS, which is from May 20 to May 28. On sheet "schedule", obviously it contains the schedule of our agents.

If you check the data on sheet "raw data", you will notice that there are multiple login and logout entries per agents. In addition, there are agents who started their shifts at night, then crossing over to morning the next day, which is their end time.

What I want to do is to capture their actual login and logout time (first login and last logout) basing on the raw data on sheet "raw data", and the result should be shown on the sheet "schedule".

I hope that I explained it well. Thank you very much in advance.