Hi everyone!
Just signed up and I think I'd be here for a long time now as I recently started a new position at my company in which I have to work with Excel more than I thought. I bought an online class at udemy and I'm still working on it.
I need your help with this small report I'm working on.
Goal: Automate the report showing how many times an agent extended breaks and lunches in intervals, 1-5 mins, 5-10 mins, over 10 mins.
What I did so far: We get daily reports in CSV format which isn't very friendly and I make few changes to it before I dump into my raw data sheet. I made a table that pulls the names and the late intervals using simple If, And & OR functions.
Challenge: Pivot doesn't work as I'm getting multiple entries in the Names column. I need the report to show how many instances of extended breaks Agents in the intervals mentioned above.
I attached the file with this thread that I worked on so far which can help you understand the issue better.
Thanks in advance. I really appreciate your help.
Praveen.
Bookmarks