Hi All,

If someone can help me create a macro to get the first login and the last log out time of an agent. I really do not know anything about macros but I think It can give a solution for this. I am unable to get it by formula. . . . Please help me out.

From the RAW sheet get the agent name and his/her first log in time and the log out time and copy it to Report Sheet.

See attached file for the sample data
LOGIN LOGOUT.xlsx


Regards,

Ca5m - Camille