1 Reply Latest reply: Nov 12, 2013 11:04 AM by Clever Anjos RSS

    Time difference between two timestamps


      Hi All,

       

      Kindly help me to resolve the difference between two timestamps

      Ex:

            column 1 :  2013-05-17 22:14:15

            column 2:   2013-05-17 22:20:15

       

      Tried out the following option (Mentioned earlier in the community but it didnt work ,returns no value)

       

       

      =

      Interval(NUM(Date#(finished, 'DD-MM-YYYY hh:mm:ss tt')-num(Date#(started, 'DD-MM-YYYY hh:mm:ss tt'))))

       

       

      Thanks in advance