I am trying to solve this for quite some time. I have a workbook with two sheets. On the first sheet it is the raw data. The raw data contains the actual log-ins and log-outs of the agents. On the second sheet is the report. My problem is, there are agents that have multiple log-ins and log-outs during the day. What I wat do is that on my LILO sheet I would only have the earliest log-in time and the latest log-out time of each agent.
Hope you can help thank you!