4 Replies Latest reply on Jun 21, 2016 2:04 PM by philip.thornton

    Adjust how time stamps are displayed

    philip.thornton

      I have a list of time stamps. They represent each minute that an event was occurring.

       

      Time
      6/20/16 0:06
      6/20/16 0:07
      6/20/16 0:08
      6/20/16 0:09
      6/20/16 0:10
      6/20/16 2:16
      6/20/16 2:17
      6/20/16 3:16
      6/20/16 3:17
      6/20/16 3:18
      6/20/16 3:19
      6/20/16 3:20
      6/20/16 3:21
      6/20/16 3:22
      6/20/16 3:23
      6/20/16 3:24
      6/20/16 3:25
      6/20/16 3:26
      6/20/16 3:27
      6/20/16 9:49
      6/20/16 9:50
      6/20/16 9:51
      6/20/16 9:53
      6/20/16 11:08

       

      I want to change the display to this:

       

        

      TimeDuration in Minutes
      6/20/16 0:065
      6/20/16 2:162
      6/20/16 3:1612
      6/20/16 9:494
      6/20/16 11:08

      1

       

      Sounds simple however it's proving to be difficult. I attached the same samples shown here.

       

      Does anyone know how to do this in Tableau? Thanks in advance for anyone who takes the time to check this out.

       

      Philip