How do I create a new column that sum the delta between to dates which are in different column? This is my data table: NameStartEnd1End2Delta between Start and End (minutes)aaa3/2/2020 21:513/2/2020 22:59 68bbb3/1/2020 18:12 3/1/2020 19:0048

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I create a new column that sum the delta between to dates which are in different column?

ileshem

How do I create a new column that sum the delta between to dates which are in different column?

This is my data table:

Name	Start	End1	End2	Delta between Start and End (minutes)
aaa	3/2/2020 21:51	3/2/2020 22:59		68
bbb	3/1/2020 18:12		3/1/2020 19:00	48

Accepted answers

txnelson

My suggestion is to first stack the columns and then create the delta column
Tables=>Stack

All comments

txnelson

Assuming the Start and End1 columns are true JMP date/time columns, all that has to be done is to use the formula
:End1 - :Start
and then set the format for the new column to one of the Duration formats

time.jmp

ileshem

Thanks for your reply.
I have several columns for "Start Date" and I want all the deltas to appear in one column.

once it will take the ":End1 - :Start" and once ":End2 - :Start".

How can I do that?

txnelson

My suggestion is to first stack the columns and then create the delta column
Tables=>Stack