Author |
Topic |
|
jcallen1
USA
6 Posts |
Posted - 01/16/2014 : 12:45:02 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): I am using Origin 6.0. I am saving a csv file with the time saved in PST time. However, when I initiate a graph in Origin I select the hh:mm in the time pull down menu to have the graph converted to 24 hour UTC time. However, the time then reflected in the graph is totally wrong. How can I obtain an accurate UTC time conversion from PST? Operating System:
James Allen |
|
Kathy_Wang
China
159 Posts |
Posted - 01/16/2014 : 03:41:23 AM
|
Hi,
Origin treats all date/time data as Julian date, and select hh:mm only means to display the time data in the format of hh:mm, so in order to convert PST time to UTC time, you will need to manually calculate the time difference, and this could be done by Set Column Values tool, which does column-based calculation.
Kathy Originlab |
|
|
greg
USA
1378 Posts |
Posted - 01/16/2014 : 08:56:19 AM
|
More specifically, Pacific Time is 8 hours earlier that UTC. Since Origin's Date and Time internal values use the integer part as day, 8 hours is 8/24 = 0.333333333333333. In your Set Column Values, you should add that amount. |
|
|
jcallen1
USA
6 Posts |
Posted - 01/16/2014 : 2:04:37 PM
|
Thanks Greg. I appreciate your help. James
James Allen |
|
|
jcallen1
USA
6 Posts |
Posted - 01/16/2014 : 8:20:06 PM
|
Thanks Kathy
James Allen |
|
|
|
Topic |
|