Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate difference in minutes

I wanna know from the Datestamp coulmn see how much minute difference it's between the previous value and the last one. I tried this formula below but got totaly different value.   Datediff = DAT...
Need Help
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

Is the column formatted as a Date type?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    ^^

    yes it is.

    • hnguy71's avatar
      hnguy71
      Icon for Super User rankSuper User
      7 years ago

      Can you provide some sample data and your expected result?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

         

        So that is that column, new data comes in every 5 min for each sensor and so on, but not alawys (sometime it drops or coming late) so I wanna make a new column to see how much it's difference between previous and the new datestamp by minutes.