calls

Hi have a question related to covert number of calls from a cumulative total per day to a calls per hour like this.... Calls that need to be converted to hourly are on cells B3 to G23. As example we take B3 = 25 and try to split on cells B12 to B14 with this formula...

Not sure if this is possible, but I am looking to add both the numerator and denominators and total them in a final cell. It is to track individual phone calls answered vs total phone calls received from a call center. Example. B2- 74/326 (74 answered, 326 total calls) C2- 55/245 D2-...

Hey all, I have a conundrum. I have a list of dates where I have received calls at my job. I can get 10-30 calls a day. I am looking for a formula to tell me how many Mondays, tuesdays, etc I have taken calls. I can't assume that i am working every monday between 2 dates cause I do have time...

I have a fairly simple pivot table which shows call center data in a very useful and intuitive way for managers. Below is the sum of the number of calls for a given hour and day of the week in March. What I need to show is the average of the calls received for a given hour & weekday (word...

Hello, I am trying to create a dual axis chart; a bar graph of total calls with a line representing percent of calls that are during business hours. My source data is a list of calls that have the following information: session ID, duration minutes, business hours?(y/n), and OS type. My thoughts...

Guys, Please can someone have a look at the below code. It essentially looks at 12 different tables and removes anything that is not "1st Attempt Made" in column D. Its doesn't seem to work all the time and sometimes leaves 'New Calls', '2nd attempt made; etc in some of the tables. Sorry if...

I've done a bunch of research, and I'm not sure a solution exists for this challenge -- but I would be grateful for any input from the forum. I have a sheet that displays financial news that is accessed from a 3rd party data vendor using Excel WEBSERVICE calls. The sheet works fine, but the...

I have a UDF in an add-in module. I decided to make some changes, so I copied it to a code module in a macro-enabled (.xlsm) test workbook. It was all working fine until I closed the test book. When I reopened it, none of the calls to the UDF were getting executed. They all showed a Value error...

Can anyone help? I am attempting to capture a percentage of a count in a column in a pivot chart. Example: In January 3000 customer service calls were made. Of which 300 were unresolvable. I am attempting to capture what percentage of January's calls could not be resolved and display it on a...

Hello, I need to find out how many calls come in, for any given day in a month from 7a-7p,. Criteria is in hour increments 7a-8a, 8a-9a, 9a-10a, 10a-11a, 11a-12p, 12p-1p, 1p-2p, 2p-3p, 3p-4p, 4p-5p, 5p-6p, 6p-7p (12 possible groupings). Example: if I had calls from 07:01, 07:59, 08:00 and 08:59...

Dear All, Hi! I have a Master Sheet which records daily entries of calls, contacts, appointments etc, of around four staff. For instance: Calls Cont App Int ... Wed, 6-Mar-19 0 0 0 2 Thu, 7-Mar-19 9 3 1 0 Fri, 8-Mar-19 6 3 0 1 Mon, 11-Mar-19 10 2 0 1 Tue, 12-Mar-19 12 5 0 2 Wed, 13-Mar-19 18...

I'm looking to create spreadsheet to collect certain keywords. i get a daily report of certain types of calls that come in from customer. i would like to track certain types of calls ex. payments, acct inquiry etc; day to day, month to month, year to year etc. So i can start forecasting used for...

Greetings, I have a macro that calls other macros. in past times I was able to run the parent macro and have the called macros work as intended. I am running into a problem now. For some reason I have macros in the 'macro' window titled as "PERSONAL.xls [then the module name].macro name"...

I have created an attendance tracker. We recently implemented a point system. I need to create a formula that will allow me to subtract one point when the date of occurance has reached one year. Example: Employee calls in on 10/18/2018, acquires a point for the call in. The point will stay in...

Hi! I have a large group of data which has number of bat calls (split by species) and then the time of each the calls. I would like to group the calls into 15 minute periods in relation to sunset eg 15 minutes before sunset, 0-15 minutes after sunset, 15-30 minutes after sunset, 30-45 mins...

Hi All, I wondering if someone would be able to help. I have a workbook that has a sheet labelled as "Pivots" with the data kept in another sheet called "Calls"...I am trying to find a way that would allow me to update the data in "calls" and for the pivots (named as PivotTable1 to 9) to...

I am trying to find a formula to find the number of concurrent calls at one time. My columns contain phone provider, outbound number, inbound number, start date and time (one cell), duration of call, and end date and time (one cell) from A to H in the order they are listed. In this stage of the...

Good afternoon, I have developed a dashboard that tracks daily activity for technicians. It's primary purpose is to see what progress is being made throughout the day and this has been working great. However I am now trying to apply some conditional formatting to the results column. In...

Hello, Is there a way for me to know when a group of function calls are done running? For example if I have a function MyFunc(), is there a way to know when all the calls are done (not each individual call), wither I call it 10 times, 20 times, 50 times etc. Thanks

I am looking to create a formula where on the top row, I have dates for each day of the week from 10/1/17 through 9/30/18. In the first Column, I have Service Areas. My data is different counts. In one data set, I am pulling just counting numbers. In another set, I am pulling a percentage...