Hi folks, the time provided from the Blynk server is Unix time. Or in other words, the number provided is how many milliseconds have passed since January 1, 1970. Excel’s ‘date’ format is the number of days since January 1, 1900. Therefore to convert the Blynk provided Unix time into the Excel format, enter the following equation into a blank cell: =“UNIXTIME” (select the cell with the unix time) / 1000 (converts to seconds) / 60 (converts to minutes) / 60 (converts to hours) / 24 (converts to days) + DATE(1970,1,1) (excel function that returns the Excel Date for a given real date. This formula without the notes is as follows:
= “UNIXTIME” / 1000 / 60 / 60 / 24 + DATE(1970,1,1)
This will return a number that excel will recognize as the actual time of the reading. The formula returned 12/25/2016 2:20 PM for the first line in the table posted by “tonk” above. Tinkering on Christmas day I see! =D