8 Replies Latest reply: Jul 15, 2014 12:59 PM by Jun Jun Wan RSS

    Timestamp and time difference in minutes and seconds

      Hey everyone,

       

      I would like to calculate the time difference between 1404743069 and 1404743034 in minutes, my formula is =interval(1404743069 - 1404743034, 'mm:ss'), and I got the result 50400:00. How can it be? The real difference is just around 1 minute. Where went wrong?

       

      Thanks a lot!