3 Replies Latest reply on Oct 30, 2018 10:39 AM by Deepak Rai

    Tableau Desktop - Time / Sum Time / Datetime to time

    Diego Brescancin

      Dear,

       

      I have Tableau Desktop with a connection to Microsoft Sql Server that is my database.

       

      In my database I have a column type time (I use this to measure the consultant hours consumption).

      When I import this column to Tableau the column turns Datetime returning "30/12/1899 00:03:07"

       

      How can I turn this column to time again (I want like this "00:03:07" HH:MM:SS),

      And then I want to sum this hours.

       

      Someone please could help me?