cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
jhcao
Level I

how do I calculate duration of time between days?

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