Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How do I create a new column that sum the delta between to dates which are in di...

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 14, 2020 6:35 AM
(608 views)

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 |

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

My suggestion is to first stack the columns and then create the delta column

Tables=>Stack

Tables=>Stack

Jim

3 REPLIES 3

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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?

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

My suggestion is to first stack the columns and then create the delta column

Tables=>Stack

Tables=>Stack

Jim