Adding hours to existing date/time column

[#1]

Hello,

I am attaching a table here with the first column showing UTC date\time. How do I use JSL to generate  a column called Taiwan Time by adding 8 hours to the 1st column?

Thanks, Cryz

[#2 · Accepted solution]

Use the In Hours() function to add the hours.

:RunFinishUTCDateTime + In Hours( 8 )

txnelson_0-1697170827433.png

JMP Date/Time values are measured in the number of seconds.  Therefore, the following formula would also work

:RunFinishUTCDateTime + 8 * 60 * 60