Tracking Login/Logout Times for users' multiple login/logouts on the multiple days.

[ZThaButcher]

Hello everyone!

I am in the process of figuring out how to make this work. I need to be able to track my beginning and ending Login/Logout times for my end-users.
I need to track end-users login and log-out times. The issue is they can log in and out multiple times a day.
Ideally, I would like to be able to take the below and automate it to just put it in and take the first login and last logout of each day of the week and compile it.
If I could paste multiple users which all would follow the same format altogether and separate per name and day of the week.
I don't know much about VBA yet but I am learning and this one is going over my head.
The format is below.
Quotation Marks are Blanks.

Agent Name	Event Name	DateTime	Duration	ReasonCode	Reason Text
Butcher	Login	11/1/2022 8:00:00 AM	00:00:00	""	""
""	Logout	11/1/2022 9:05:00 AM	001:05:00	1	Logout
""	Login	11/1/2022 9:06:00 AM	01:00:00	""
""	Logout	11/1/2022 10:06:00 AM	01:00:00	5	Undefined
Z	Login	11/1/2022 08:00:00 AM	00:00:00	""	Login
""	Logout	11/1/2022 12:00:00	4:00:00	""	Logout
""				""

 

[ZThaButcher]

So I have Tried the following Code Below and it does not seem to want to work with the DateTime being together and I don't want to have to separate it each time if possible. I want to be able and copy and pasta this in and get the data I'm looking for per agent.

=MAX(IF(ISNUMBER(SEARCH(M1,$C$2:$C$199)),$C$2:$C$199,))
=MIN(IF(ISNUMBER(SEARCH(M1,$C$2:$C$199)),$C$2:$C$199,))
M1 Referring to the date above.
I was only trying to get this to work for one person at a time but I have not been able to even get that far yet without separating the date and time to separate columns.

10/24/2022​	10/25/2022​	10/26/2022​	10/27/2022​
Login	Login	Login	Login
12:00:00 AM​	12:00:00 AM​	12:00:00 AM​	12:00:00 AM​
Logout	Logout	Logout	Logout
12:00:00 AM​	12:00:00 AM​	12:00:00 AM​	12:00:00 AM​