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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 TIME CONVERSION FROM PST TO UTC
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

jcallen1

USA
6 Posts

Posted - 01/16/2014 :  12:45:02 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

greg

USA
1378 Posts

Posted - 01/16/2014 :  08:56:19 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page

jcallen1

USA
6 Posts

Posted - 01/16/2014 :  2:04:37 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks Greg. I appreciate your help.
James

James Allen
Go to Top of Page

jcallen1

USA
6 Posts

Posted - 01/16/2014 :  8:20:06 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks Kathy

James Allen
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000