9 Replies Latest reply on May 27, 2016 4:21 AM by Andrew Watson

    Total Time

    Oliver Shingfield

      Hi guys,

       

      I have an excel document with time's per agent of how long they spend on the phone.

       

      So the excel document looks like this..

      Agent Name

      Time Spent on phone
      Agent 107:49:00
      Agent 207:30:00
      Agent 306:59:00

       

      I now need to add up the total time that they are spending on the phone in Tableau.

      Does anyone know how to do this? Grand total isn't working as the time is not a measure.

       

      If anyone can help that would be great:)

       

      Kind Regards,

       

      Oli