Posts by tlwalker

    Re: COUNTIF Function and Creating Pivot Table


    Ok, I think I KINDA figured it out. Don't get sick of me yet Herbds, lol. I entered info in and clicked update. This time it did not take the Pivot Table away. But what I am still confused about is, when I enter the date would I need to enter a time right next to it, where do I get that time from?

    Re: COUNTIF Function and Creating Pivot Table


    On your Table 2 the time has to be the same as the time on the Pivot Table. I have to enter in hold times so it is important to see that a call was placed on hold for 0:03:25 before hanging up between 6:00-6:30am. I tried to enter info, but when I click on Updatean error message of "Run-time error '1004': Cannot open PivotTable source file Documents and Settings etc". I have the option to press End, Debug, or Help. When I press End it takes away the Pivot Table. When I press Debug it goes to Microsoft Visual Basic for Applications Module with what looks like Commands and takes away the Pivot Table.

    Re: COUNTIF Function and Creating Pivot Table


    I love the look of the example you provided, but I'm still confused as to how I would go about filling in the information. I just want to be able to enter information in and have it calculate under each 'Seconds' column. Whatever way you would advise is easier then that will be the way I go. I thank you for helping me this far Herbds7.

    I have to enter in the average abandoned call times along with the amount of abandoned calls each month. So far I created this worksheet I have attached. I enter the info and the top and count out each day for that month and seperate it into the chart I created below. It is suppose to be a total of calls by each half hour increment. I have to enter time in as "0:00:00. I need for it to automatically calculate and go into its column. Either both Abandoned Calls & Seconds or Seconds. The seconds columns are 0-4, 5-9, 10-14 & >15.

    • I created a table below and my supervisor would like for me to “add a metric on how many days are under 1:00 vs Over 1:00 as compared to the total number of days (as a percentage)”. Could you please assist me with this?
    • Date Max Delay
    • 10/1/2013 0:00:41
      10/2/2013 0:00:51
      10/3/2013 0:00:23
      10/4/2013 0:00:54
      10/7/2013 0:02:04
      10/8/2013 0:01:02
      10/9/2013 0:00:12
      10/10/2013 0:00:51
      10/11/2013 0:00:14
      10/14/2013 0:00:25
      10/15/2013 0:02:30