Blynk local server time date stamp for logs

Issues and Errors
1

Hi, I seem to be having problems converting Unix time in Blynk logs to normal date and time - do I assume the Blynk local server time/date stamps using the date/time configured for my server i.e. I’m using Windows 10 so I assume i uses the time an date set by it ?

Also - is the time stamp in miliseconds or seconds from 1/1/1970 ?

2

Yes.

Here is formula for excel :

=((B1/(60*60*24)/1000+25569)) without your timezone.

3

awesome, thanks - that gives me correct date - how do I get the time (and also add in my timezone) ?