cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
cchueng
Level IV

Adding hours to existing date/time column

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

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Adding hours to existing date/time column

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
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Adding hours to existing date/time column

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
Jim

Recommended Articles