Excel DateTime

Share icon

Mon, 12/29/2014 - 06:36 pm

First off, I am new to IGOR and am still learning for forgive me if this has been answered already. I am having an issue taking Excel serial DateTime and putting it into igor format. I have very large .csv files and when I attempt to import the waves from the file and go to change it to igor date time it just produces a blank wave. Ordinarily I would just change the format in excel first but the files are too large for excel to open. How can I go about changing it over to display the date and time?
Execute this for relevant help:
DisplayHelpTopic "Excel Date/Time Versus Igor Date/Time"

If that does not help, copy/paste 20 or so lines from your file to a new file, zip it, and attach it to a post here. Also indicate in the post the command you are using to load the data and the commands you are using to convert from Excel to Igor date/time values.

December 29, 2014 at 09:42 pm - Permalink

hrodstein wrote:

If that does not help, copy/paste 20 or so lines from your file to a new file, zip it, and attach it to a post here. Also indicate in the post the command you are using to load the data and the commands you are using to convert from Excel to Igor date/time values.


Again forgive my simplistic approach but I would take this data file and use the load delimited text. I load it as a Date and Time column format. I don't know any other way to import data or convert date and time yet. I am still learning and adjusting. Any help or guidance is appreciated.
sample.csv

January 6, 2015 at 10:46 am - Permalink

You can't load that file as date/time because it is not in date/time format. Date/time format looks something like this:
2015-01-06 12:13:14

Your file is in regular numeric format. Therefore you need to load it as a regular number. To convert it to an Igor date/time wave, follow the instructions in the help topic that I referenced above.

January 6, 2015 at 11:15 am - Permalink