chat

Hi All, First off thanks for taking the time to read the following question/issue/plea for help I have a data set in pivot form which i have created a pivot chart and wondered if there was anyway that the Legend that is displayed could only show the items which have a greater or equal number...

Hi Team, I have below data and I would require a formula to see how many activity each person has processed in an hour, for every hour I would like to show the progress in different table. I want to see the progress for 12 hours. I input the processor name in column A in sheet 1 and 2 to get...

I'll try to simplify this question; I would like a cell to display a return value/answer "Yes" or "No". I would like to know if there's a simpler way to formulate this cell; =IF(E8="","",IF(E8="Chat (CC)","Yes",IF(E8="Chat (OCS)","Yes",IF(E8="Chat (RSCC)","Yes",IF(E8="Credit Card...

Hi, I am looking for convenient way to find productive time of resources working in shifts to handle chats. I get chat handled report with start time, end time and resource ID who handled it. They can work of one or more chats at at time and there can be multiple breaks or idle time during the...

I have a PivotTable with names as the row and for the columns I want the user to be able to easily switch between chat total, email total, and call total, and then the values be whatever the chat, email, or call total is for the employees. Is there a way to do this without using the PivotTable...

Hi, I have a spreadsheet which lists a customer ID, Chat Start Time, Chat End Time, and Date. I need a formula that will look up the chat end time of the first interaction with a particular customer ID, then work out the time difference between that and the chat start time of the next...

Hi If I delete plotted area grid lines in excel chat, is there anyway to get them back (not to use undo)? Thank you.

Hi I pretty much have no prior knowledge to visual basic, or the macro/function in excel for that matter, so bare with me. I'm reading through a MASSIVE chat log that has been imported to excel. The format of the log is like this: (all fictional) <tbody> Timestamp Direction Chat member ID#...

Hi, I am trying to write VBA code to login and chat using Excel VBA. I have used Shell command (as shown below) to open gtalk, but not able to figure out from there. Shell """" & C:\Users\Google\Google Talk\googletalk.exe & """" Thanks in advance for your help. Regards! Vikas

Hi Everyone, I would just like to share my 'Excel Messenger'. Please feel free to suggest/develop and look into my code. You can download it here.. http://www.mediafire.com/file/9oqx94x37ywxrga/BetaExcelMessenger.xls Sorry for posting an external link. *notes - can be used in LAN...