title: SSRS total for time
body: <p>I have a table as such:</p>
  
  <pre><code>----------------------------------------------
  Name    |     Activity     |    Activity Time
  ----------------------------------------------
          |                  |
          |   L030           |    07:15:00
  Dan     |                  |
  Smith   |------------------------------------
          |                  |
          |   L031           |    01:00:00
          |                  |
          |------------------------------------
          |   Total          |
          |                  |
  ---------------------------------------------
          |                  |
          |   L030           |    01:15:00
  Steve   |                  |
  Jones   |------------------------------------
          |                  |
          |   L031           |    06:00:00
          |                  |
          |------------------------------------
          |   Total          |
          |                  |
  ---------------------------------------------
  </code></pre>
  
  <p>The name acts as a parent group for the activities and their associated times. </p>
  
  <p>I thought that it would be a simple case of using the "add total" function to generate a total amount of time, however the option is greyed out.</p>
  
  <p>Is it possible to use the "add total" function with times? If not, is there a workaround which would do the same job?</p>
  
  <p>Thanks</p>