Time Used per Interval

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Pepe,

I have attached a file for your perusal.

I have entered some of the fields aligned to how I need the data expressed.

Thank you in advance.

regards,
Murtadau

Is anyone able to assist with this one??

Can you explain in more detail

With the latest attachement. I show how I would want the data positioned.

I need to see whether an agent was within adherence. This is a temporary solution as I will be moving to building a SQL model and then building a report in Visual Studio.

The report we get from CMS - Tace by Location gives a record for everything that the agent does on the Telephony System.

So everytime they change their AUX state it will capture a new record.

The problem is that a record could span over multiple 15 minute intervals and I need to capture it over the multiple intervals, but I cant seem to figure it out.

As an example Cell (G5) has a Aux time of 00:35:35 seconds, with all options I have tried this figure just gets placed as a whole in one cell. However, I need it to be presented in the 4 corresponding Cells as depicted in the attachement. Namely (J5:M5)

Thanks Punnam for replying

in j4
=IF(AND($C4<K$2,$H4>J$2),MIN(K$2,$H4)-MAX(J$2,$C4),0)

if it starts before the period ends and ends after the period starts, there should be some time in the period

this being the case you want the minimum of the end time and the end of the period, and tax from this the maximum of the start time and the start of the period

Davsth ,
I am not able to get the logic but its work great JOB.

Murtadau_Gabier
I Hope you got it cleared

Punnam