4 Replies Latest reply: Feb 15, 2017 6:45 PM by Marco Wedel RSS

    Convert string to the timestamp

    Marek Waszczak

      Could you help me write the formula changing the string to the seconds?



      so far I have managed to change the names to the seconds value but still how to count total of all.


      The problem is that the null value is not stored as a 0


      so instead of 0 Days 0 Hours 25 Minutes  there is only 25 Minutes



      So the problem is how to convert string to the number and calculate total of seconds if we have for example:


      1 Day 10 Minutes

      4 Days 2 Hours 30 Minutes

      30 Minutes

      10 Hours  10 Minutes


      and so on....