2.14 FAQ-424 How do I import custom date and time data?

Last Update: 7/30/2015

By default, date and time data imported to the Origin worksheet will be treated as text. While you can always configure the column to handle your date and time data correctly after data import, you have the option of specifying a custom date-time format before the data are imported. This is done using the Import Wizard.

To learn how to import date and time data and specify a custom date or time format on import, see this tutorial.

Note that upon import, the custom date-time format is stored in the worksheet column. If you save the project file, the custom format is saved with the OPJ.

Keywords:day, hour, minute, second