VBA Code Required - Employee Login Logout

[Yadavgiri]

Dear All,

Hope everyone doing good.

Attached data has multiple login logout of the employee who works on different Media Type (Email, Chat, Voice) and its 24/7 Work environment.
I need VBA Macro to be created to capture First Login date time & and Last Login Date time captured for the day and login hours delivered.

I have also attached a sample file as to how the data should be captured by VBA and have highlighted in Yellow.

Could you please help VBA Code created for the above.

Let me know for any clairifications.

Regards,
Yadavagiri

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ml#post5318110