cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
ileshem
Level III

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

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 68
bbb3/1/2020 18:12 3/1/2020 19:0048
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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

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

View solution in original post

3 REPLIES 3
txnelson
Super User

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

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

Jim
ileshem
Level III

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

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
Super User

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

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