cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. ET on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

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