cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
View Original Published Thread

how do I calculate duration of time between days?

jhcao
Level I

Hi All,

I am new to JMP.  How do I calculate the difference between time? For example, when I use JMP to calculate the duration of time for 1Jan2021 11:45PM and 2Jan2021 12:30AM, I get a negative number instead of 45 minutes.  

 

Thanks

1 REPLY 1
jthi
Super User


Re: how do I calculate duration of time between days?

Check out Date Difference function from scripting index

 

Names Default To Here(1);
Date Difference(
	Date DMY(31, 1, 2015),
	Date DMY(1, 3, 2015),
	"Month",
	"start"
);
-Jarmo