Login and Logout Template

Hi,

I am working on a template for quite some time and I am stuck, I am trying to create a template wherein it captures the initial login of the agent based on their set schedule for the day. The data is from AVAYA CMS and looks like this when exported to excel.

CMS.jpg

I attached the template I am working on and also the Login and Logout file (LILO), I was hoping someone can help me with either a formula or macro that can capture the initial login of the agent/s and I can take it from there. Hope you guys can help out.

please guys...anyone who can help?

Hi,

Please find enclosed file updated with the formula.

Highlighted rows in Yellow in Summary sheet have login details captured, however, logout details isn't captured in sheet named CMS DUMP. hence, there is a ##### shown in column named Time Spent in Summary sheet.

Highlighted rows in Orange in Summary sheet doesn't have login and logout stamp in CMS Dump sheet.

Also, i have given a formula in CMS Dump sheet in column Y & Z to capture the login and logout in time format.

Let me know if this helps you.

Regards,
Yadavagiri