topic Re: Creating a column of time intervals in Discussions

Creating a column of time intervals

Alicia — Tue, 07 May 2019 14:45:49 GMT

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):

Is that possible from the formula builder in JMP?

Many thanks for help in advance!

Re: Creating a column of time intervals

txnelson — Tue, 07 May 2019 14:50:47 GMT

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)

Re: Creating a column of time intervals

Alicia — Tue, 07 May 2019 14:56:21 GMT

Work great, thanks so much!