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
- :
- Discussions
- :
- Re: Easy Question

Topic Options

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

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

Dec 6, 2018 12:58 PM
(419 views)

New to setting up spreadsheets in JMP and I have an easy question. I simply need to calculated elapsed time (in days) with my process dates and times. So the proces goes about 15 days with one or two time points per day. I am embaressed as this should be easy, but I can't get it to work.

How do I do that in JMP? Thank you- MB

7 REPLIES

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

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

Dec 6, 2018 3:51 PM
(396 views)
| Posted in reply to message from uday_guntupalli 12/06/2018 04:01 PM

I will try that- thank you.

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

So this is what I have, and forgive me, I have no programming skill. How do I get it to work from here. Thanks and I wish I could buy you coffee ;)

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

Highlighted
##
##### Re: Easy Question

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

Here is the formula you want to use for your Elapsed Time (Days) column

`Date Difference( :Date Time[1], :Date Time[Row()], "Day", "start" ) );`

Jim

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

Do you need the Row() function or a subscript with the second argument if this expression is used in a column formula?

Learn it once, use it forever!

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

Thanks. Part of the problem is I will have multiple runs, and it needs to recalculate for each set of data. This is biology data, so I have several runs that I hope to have elapsed days on the x axis, and all my outputs on the y axis (like metabolism indicators). I could just put days 1, 2, 3 etc., but sometimes I sample in the morning and sometimes in the late afternoon, so days is less accurate than elapsed days. I will probably use this for other calculations once I get used to this interface. Cheers