Creating an Time elapsed column from a datetime column

babn — Thu, 15 May 2025 22:40:37 GMT

Hi All,

Help with this would be greatly appreciated. I am trying to create a new column that generates the elapsed time in hours from a column that has date/time in the following format, "04/22/2025 11:16 AM."

Thanks!

Barbara

Re: Creating an Time elapsed column from a datetime column

babn — Thu, 15 May 2025 23:25:23 GMT

Found a solution that works!

Re: Creating an Time elapsed column from a datetime column

jthi — Wed, 21 May 2025 16:15:10 GMT

Could you post your solution? If you have your data correctly formatted as date in JMP the difference will be in seconds and you can convert it to hours dividing it by 3600 or In Hours(1) or just change the format to Duration this might be unnecessary (generally I would try to keep the values as seconds and play around with formats, but this varies case by case). Below is example in a form of JSL

Names Default To Here(1);

dt = New Table("demo",
	Add Rows(4),
	Compress File When Saved(1),
	New Column("Times",
		Numeric,
		"Continuous",
		Format("ddMonyyyy h:m:s", 22, 0),
		Input Format("ddMonyyyy h:m:s", 0),
		Set Values([3830699241, 3830702820, 3830710041, 3830882841])
	)
);

dt << New Column("Dif", Numeric, Continuous, Format("hr:m:s", 13, 0), Set Property("Units", "hr:m:s"), Formula(
	Dif(:Times)
));

For more complicated comparisons you can use Date Difference(), in this case it would look something like this (note that the intervalName is "hour" and not "second" in this example)

Date Difference(
	Lag(:Times),
	:Times,
	"hour",
	"fractional"
);

topic Re: Creating an Time elapsed column from a datetime column in Discussions

Creating an Time elapsed column from a datetime column

Re: Creating an Time elapsed column from a datetime column

Re: Creating an Time elapsed column from a datetime column