Creating a column of time intervals

[#1]

I have a column containing date & time data and I would like to create a new column that calculates the time interval between the current row and the previous row?

For example, if I have

Row 1: 01/01/2019 15:00:00

Row 2: 01/01/2019 15:00:05

Row 3: 01/01/2019 15:00:12

then I want to create a new column that returns the values (in seconds):

-

5

7

Is that possible from the formula builder in JMP?

Many thanks for help in advance!

[#2 · Accepted solution]

Assuming your column of Date Time values is a valid JMP Date Time column, and that for illustration purposes, the column has the name, "DateTime", the formula would be

:DateTime - Lag(:DateTime)

[#3]

Work great, thanks so much!