0 Replies Latest reply: Feb 19, 2017 5:32 AM by Venkatesh botla RSS

    How to convert time stamp into relative time

    Venkatesh botla

      Hi Team,

       

      Please help to convert the timestamp into relative time

       

       

      below is the sample data:

       

      date                                   value


      11/14/2016 18:20:10.9601411262.667
      11/14/2016 18:20:10.9701411279.167
      11/14/2016 18:20:10.9801411295.667
      11/14/2016 18:21:10.9901411312.167
      11/14/2016 18:20:11.0001411328.667
      11/14/2016 18:20:11.0101411345.167
      11/14/2016 18:22:11.0201411361.667
      11/14/2016 18:20:11.0301411378.167
      11/14/2016 18:20:11.0401411394.667
      11/14/2016 18:23:12.9801414381.167
      11/14/2016 18:20:12.9901414397.667
      11/14/2016 18:20:13.0001414414.167
      11/14/2016 18:24:13.0101414430.667
      11/14/2016 18:20:13.0201414447.167
      11/14/2016 18:20:13.0301414463.667
      11/14/2016 18:25:13.0401414480.167
      11/14/2016 18:20:14.9801417549.167
      11/14/2016 18:26:14.9901417565.667
      11/14/2016 18:20:15.0001417582.167
      11/14/2016 18:27:15.0101417598.667
      11/14/2016 18:20:15.0201417615.167
      11/14/2016 18:20:15.0401417631.667
      11/14/2016 18:28:15.0501417648.167

      Out put should be like below :

       

      line.PNG

       

       

       

      by using timestamp, i should get the x-axis as relative time (whole time stamp need to convert into seconds)

       

      FYI, starting time stamp should be consider as 0 (zero) then 300 seconds need to add for the starting time like that it should go in x-axis .

      (starting time - (minus ) next time difference in seconds need to add into the relative time .

       

       

      Thanks,

      Venkatesh