cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles