cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
corkman1987
corkman1987
Level II

Manipulating Timestamp

Created: Mar 6, 2023 04:23 AM  |  Last Modified: Jun 8, 2023 9:31 AM (3047 views)

Hi I am struggling to convert a Timestamp into numeric format. I basically want to use the timestamp to create an Elapsed Time column. I am having difficultly achieving this with JMP16. Below is an example of the format. The change from 12:59 to 01:00 also seems to cause issues for me.

 

corkman1987_1-1678094435310.png

 

I was able to work with excel and manipulate the data to give me an Elapsed time in minutes (from row 1 as starting point). But I would prefer to use JMP and to create a script for it.

 

Thanks

 

 

 

 

0 Kudos
11 REPLIES 11
corkman1987
corkman1987
Level II

Re: Manipulating Timestamp

Mar 7, 2023 09:26 AM (600 views)  |  Posted in reply to message from txnelson 03-07-2023

thank you very much for your help. your script is working well for me even when in UK date/time settings.

0 Kudos
txnelson
Super User txnelson
Super User

Re: Manipulating Timestamp

Mar 6, 2023 09:34 AM (639 views)  |  Posted in reply to message from corkman1987 03-06-2023

I am not seeing the error.  See the display below.  I have also attached my data table.  The Time 2 column is the same values as the time column, but with the display format set to display the actual numeric data values behind the date/time.  It is the number of seconds since January 1, 1904.  Time 2 has the formula       :time   but the format is changed to Fixed Dec, 20, 3.

txnelson_0-1678112810688.png

I ran the code under both JMP 16 and 17, with the same results.

 

 

Jim
corkman1987.jmp