I was downloading some interactive trends this week from groov and with the help of product support noticed that the trend time stamps are displayed in UTC Time Zone.
With manipulating the timestamp in Microsoft Excel we could get it to my time zone of UTC+10 with the following formula:
Original formula and data:
=(A2/1000 + (“1/1/1970”-“1/1/1900”+1) * 86400) / 86400
Modified to add +10 hours
=(A2/1000 + (“1/1/1970”-“1/1/1900”+1) * 86400) / 86400 +10/24
My question is though can there be a setting added into groov that nominates the time zone you are in so you don’t have to worry about the different formula?