Creating a column of time intervalsI 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!
Re: Creating a column of time intervalsWork great, thanks so much!Re: Creating a column of time intervalsAssuming 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)
