Hi all, This is my first post on this forum, and I am also fairly new with Igor, so my questions may look trivial.I have an Igor file with a time serie of random data.I need to plot them on Excel, but both softwares seem to handle dates differently (for example: 06/01/2011 gives 3389770151 in Igor and 40695,3674884259 in Excel).
Will be sending a sneak peak of my character this week.
#theshadowwithin," she wrote back in November, announcing her next feature film project.
Things have been very—eerily—quiet on the Lindsay Lohan front over the past few months. ) 2014 OWN reality show, in which every episode seemed to center primarily around Lohan needing to move 15 large boxes from one room to another, Lohan has maintained a pretty low profile.
My simplistic approach was to set excel's default to 1904 system, divide Igor's value for 06/01/2011 by 86400 (secs/day) in excel and change the cell format to date/time.
The Mean Girls actress, 29, first hinted at a romance with the 22-year-old businessman when she posted a shirtless photo of him to her Instagram account on Saturday, March 5. I hope that #Elizabeth Taylor is watching over me to see this #icons 🙏🏻 thank you to my #bff @patscar for inviting me to Gstaad for the first time since I was 2 years old 🙏🏻🇨🇭 A photo posted by Lindsay Lohan (@lindsaylohan) on According to The Mirror, the new pair reportedly met in London where the “Rumors” singer has been living for the past several years.
Lohan, who has managed to keep a low profile overseas after years of making negative headlines in the States, seems to finally have her life back on track.
In addition to finding a match in the Moscow-born real estate mogul, the former child star has returned to her acting roots."My first day on my new film!!!!
Is there a simple way to convert Igor dates to Excel dates?
Thanks for your help I'm not all that familiar with date/time operations, but a quick perusal of the relevant help docs shows that Igor date representation is based on seconds since midnight 1/1/1904 and excel for windows is based on days since 1/1/1900. Maybe it will serve as a starting point for you and maybe, most likely, someone will have a significantly more elegant approach.
You can change excel's default to days since 1/1/1904, but it is still base on days, with fractions of a day (obviously, I guess) represented by the fractional part of that value. PS The Igor value for 6/1/2011 AM should be 3389762951.
Also, apparently excel for the Mac is, by default, based on days since 1/1/1904.