The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Converting from timestamp to numeric value?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
rjt211 Posted - 01/17/2017 : 4:42:11 PM
I'm trying to compare data (collected using several different sensors) for which I have temperatures for a specific timestamp (dd/mm/yy HH:mm:ss) but I really need to be able to plot them against a third variable - z-height. As you can see, I can correlate the z-height to a specific timestamp but I can't work out how to plot the z-height against temperature as the timestamp is different for each set of temperatures.



Any idea on how to convert the timestamp to a z-height or something? I tried plotting a graph of timestamp against z-height and using the equation to convert the timestamp but presumably because the timestamp is a very specific format and not a regular number I confused something. (Mostly myself.)

Origin Ver. and Service Release: OriginPro 2016 (Student version) b9.3.2.303
Operating System: Windows 8.1
1   L A T E S T    R E P L I E S    (Newest First)
cpyang Posted - 01/17/2017 : 7:38:00 PM
Your timestamp column is right-justified so it is already in correct numeric date time internal representation. You can check by changing the date display format to make sure.

Then you will need to interpolate your temperature data's Timestamp to the Z-height data's timestamp so they can have a common timestamp.

CP

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000