| T O P I C R E V I E W |
| jcallen1 |
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 |
| 4 L A T E S T R E P L I E S (Newest First) |
| jcallen1 |
Posted - 01/16/2014 : 8:20:06 PM
Thanks Kathy
James Allen |
| jcallen1 |
Posted - 01/16/2014 : 2:04:37 PM
Thanks Greg. I appreciate your help.
James
James Allen |
| greg |
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. |
| Kathy_Wang |
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 |
