4 Replies Latest reply on Aug 14, 2015 9:30 AM by Philip Townshend

    Formatting Date and duration

    Philip Townshend

      Hi Guys,


      I have a problem formatting my data. It consists of a date as well as a duration (30.12.2014 00:01:08). So its dd.mm.yyyy hh:mm::ss

      No what I'm trying to do is to format it in order to only be shown the duration in seconds and get rid of everything else.


      Does anyone here know how to do this?


      Thanks in advance