title: How to group a column which is in hours by days and months in a pivot table?
body: <p>I am new to excel pivot tables and need some help from excel experts here. I have a table with agent name, ticket number and hours since the ticket was assigned to the agent as can be seen below:</p>
  
  <p><strong>SOURCE</strong></p>
  
  <pre><code>  agent             ticket               hours since assigned
  -----------------------------------------------------------
    agent1            12345                     23
    agent2            23456                     10
    agent2            78964                     45
    agent5            45567                     148
    agent5            98654                     15
    agent6            54678                     2
    agent4            76543                     100
    agent4            98765                     56
  </code></pre>
  
  <p><strong>THE PIVOT TABLE</strong> that I am looking for is - number of tickets agentwise grouped by days. I hope this is possible in excel. Please guide me.</p>
  
  <pre><code>agent        1 to 2 days          2 to 3 days            3 to 4 days
  --------------------------------------------------------------------------
  agent1           2                  5                        4
  agent2           5
  agent4                                                       2
  </code></pre>
  
  <p>Is it also possible to group the same data by weeks, months?  </p>