cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles