This is for Netatmo weather station enthusiasts. It is one of those nuisance problems that caused me to waste a day.
Netatmo data downloads provide a Timestamp for each reading time. It is expressed as Unix time for your time zone (in my case Bangkok), a big number such as 1467025349. Because there has been a lot of messing around with time formats by Microsoft Excel over the years, there are dozens of conflicting formulas out there that are supposed to do this conversion.
I am working with the 2011 Mac version of Excel and after a lot of frustrating attempts finally arrived at a formula that does the conversion that matches Netatmo's conversion shown in the "Timezone: Asia Bangkok" column which for some reason doesn't import into Excel. These are the kind of headaches that make me long for the days of Lotus 123.
Excel date=((Timestamp+25200)/86400)+24107
With the Timestamp example of 1467025349 this should yield (in Excel date language) 41086.75172 or 6/27/16 18:02.
Netatmo's help facilities are not the greatest when it comes to this kind of thing, so I hope this fills the gap for now.
No comments:
Post a Comment