calls

#3[/URL] 33333]Hi, #3[/URL] 33333]I'm new with excel and and forum, so if i'm posting to wrong place, please let me know! #3[/URL] 33333]I'm trying to figure out on hot to calculate daily utilization of staff. #3[/URL] 33333]From the system i can generate this information: #3[/URL] 33333]#1...

Hello, I am having problems calculating with function "COUNTIF". According to the given data I am supposed to calculate the number of calls for each minute in the Busy hour(60 minutes) using "COUNTIF" function in excel. https://imgur.com/a/f89ayMm For example - if I take minute number 2...

The first column is the start time and the second is the end time of a call. I want to count the number of calls that are going on in 1 hour time slots. <colgroup><col><col></colgroup><tbody></tbody> <colgroup><col><col></colgroup><tbody> 15/02/2018 08:04 15/02/2018 09:22 15/02/2018 08:05...

hi guys, New to the forum. However been referring to this forum from general google searches for years now. Seems today im at an impasse for a new problems which is quite specific. I've no doubt heads will be scratching. I need to be a manner in which I can determine the number of concurrent...

Hi, Not got much knowledge of VBA, so thought i'd ask. I have 2 workbooks, 1 has a report from my inbound dialler that shows numbers called and the disposition from one of our agents (sale, call back etc.), the other workbook is a download from Google Adwords that shows the calls made and...

Hi All, I have a table with information, to indicate the type of calls being made and each staff name, however using a manual table i can find out who has made calls and who hasnt. Using a Pivot table i can find out who has made calls and have lovely graphs, what i cannot find out, is how do i...

Hi, I did a quick search but could not find anything that would provide me with a solution to my problem. I have a number of hours showing up in column P as 152:01:09 (one hundred and fifty two hours, one minute and nine seconds), however in the address bar it appears as 1/6/1900 8:01:09 AM...

Hello Everyone, I'm afraid i am not able to put the picture of the file for better understanding. Though, i tried and failed. I will try my best to explain. In the below grid-1, in front of the date (1-Feb), i want to insert a formula that uses the grid2 (mentioned even below). The formula...

Hello, I have read that it is possible to be able click on a slicer and send one or multiple emails, which is cool. The question I have which I have not yet found an answer to, is it possible to be able to click on a slicer and make a call in Google Hangouts? thank you

Hi All, This has had me stumped all day and was hoping somebody could steer me in the right direction. I have a telephone bill (list of calls) where I need to create a separate tab for each users calls. I have created a pivot table and used the "Show report filters pages" option which gives a...

Hi can anyone help? I have a CommandButton12 that calls CommandButton1 multiple times. Sheet2 eg Private Sub CommandButton12_Click() Call CommandButton1_Click Call CommandButton1_Click Call CommandButton1_Click End Sub CommandButton1 calls different Sub routines. If I want to call...

I have a simple chart showing calls by day average. Year 1990=100 1995=200 2010=400 2014=515 I want to create a simple line graph and add a trendline showing what calls might be in 2025. Help please. I think I'm over thinking this!

Happy Holidays Excel Experts! I am curious to know if anyone has thoughts on the following issue I'm encountering. I have 4 modules that each run a separate routine. The first module is the master. It calls the second module which in turns calls the third which calls the fourth and final...

Dear all, I am going to change a bundle of excels which named according to incomplete ascending number( etc: first one calls 1_2016, second calls 2_2016, but the third calls 4_2016, etc.), my purpose is renew their names in 2017 instead of 2016. However, I encounter into using loop, when I set...

Dear Excel users, I have a problem to auto filter a predefined list in a combo-box. I have two comboboxes on a Userform - the first one calls up job numbers (Reg5) and the second one calls up activities (Reg6) that is related to whatever is selected in Reg5. Because the list in Reg 5 is massive...

So I have multiple macros to keep things clean. It may be extra macros but it help in case files change etc. I have a master 'CallMacros' macro assigned to a button Clicking this button, calls 11 macros, let's call them Macro1, Macro2, Macro3, etc. Each macro is: Workbooks.open (a...

I receive data from the Call Center software each week. In my workbook the data is entered into a worksheet for each week labeled W-01 to W-52. The last sheet is labeled COMP. Each sheet has three shifts data on it and all sheets are exactly the same. Below the data I copied what the COMP sheet...

I created a map with 3 d Map Montreal's uiing open data for 311 calls, I selected a subset for calls regarding calls for rat extermination. The data has geo location for each call. I then tried to amend the tour to a regional map with electorial district by importing a kml file that was also...

Every day I get a file from another department like the layout in Sheet 1. I need a way to auto populate Sheet 2 which has the names as headers horizontally instead of vertically. Currently I am doing this manually. I've tried using Index/Match without success so I was maybe looking for...

Hey all, I want to calculate how many calls is needed (answered in Service Level column C) to reach the target (column G). In below example this would be 1156, not taking in account that calls are abandoned. So incoming calls and answered calls will increase. How can is calculate this using the...