408252_en-US

liliconcom

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

AnalyticsData TableRe: 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"
);