Retrieval of Blynk data

[ldb]

LOVE THE CSV EXPORT! Two Things needed, Request From Hardware and Time Range

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…