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

how do I calculate duration of time between days?

jhcao — Sun, 11 Jun 2023 11:49:44 GMT

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

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

jthi — Tue, 10 Aug 2021 07:09:39 GMT

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"
);