Dears,
please i need help in an issue related to mathematics somehow, need some ideas to get the desired request,
in recap, i have a worksheet that have some data listed to:
>>"Agent Name",
>>"Chat ID", this column have an Unique IDs for chats,
>>"Visit Time" this time is concern the start time of the chat,
>>"Interval", i rounded the visit time to Quarters,
>>then a column filled with the "End time" for the Chat,
>>at last "Chat Duration" this concern the duration of each chat,
any chat have start time, end time and Duration.
may every agent receive 2 chats or 3 at the same time, so that we can notice the chat duration at interval is "0:28:00", while the interval duration is "0:15:00".
what i looking for is needing to the available time or the free time for each agent in each interval, in considering the cross time chats: it's mean the chat may start in interval and end in another interval, and the agent may have more than one chat in the interval time, therefore i can't get the free time by ("0:15:00"-chat time)
hope if that is available to be handled by excel.
the workbook uploaded
https://onedrive.live.com/redir?resid=DCE82BAEAB01A7F0!890&authkey=!AEcGskFvqKh-q0U&ithint=file,zip
Gratefully,
please i need help in an issue related to mathematics somehow, need some ideas to get the desired request,
in recap, i have a worksheet that have some data listed to:
>>"Agent Name",
>>"Chat ID", this column have an Unique IDs for chats,
>>"Visit Time" this time is concern the start time of the chat,
>>"Interval", i rounded the visit time to Quarters,
>>then a column filled with the "End time" for the Chat,
>>at last "Chat Duration" this concern the duration of each chat,
any chat have start time, end time and Duration.
may every agent receive 2 chats or 3 at the same time, so that we can notice the chat duration at interval is "0:28:00", while the interval duration is "0:15:00".
what i looking for is needing to the available time or the free time for each agent in each interval, in considering the cross time chats: it's mean the chat may start in interval and end in another interval, and the agent may have more than one chat in the interval time, therefore i can't get the free time by ("0:15:00"-chat time)
hope if that is available to be handled by excel.
the workbook uploaded
https://onedrive.live.com/redir?resid=DCE82BAEAB01A7F0!890&authkey=!AEcGskFvqKh-q0U&ithint=file,zip
Gratefully,
