9 Replies Latest reply on Sep 16, 2015 4:25 PM by Emily Chen

    Find Duration between two columns

    Dinesh Babu

      I have two columns of data of the following format:

       

      FinishTimeSubmitTime
      2015.09.06 12:31:20 GMT2015.09.06 12:31:04 GMT

       

       

      I want a third column finding the time difference (ie to find the duration)

       

      Please Note:

       

      Sometimes the data will be like this:

       

      2015.09.06 00:15:23 GMT2015.09.05 23:58:05 GMT

       

      Here the time difference is a bit complicated where date must also be considered.

       

      I am new to Tableau. Help would be appreciated. Thanks.