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....