Exporting History data from atvise SCADA in CSV file (if applicable for exporting data in this format), the format time will be in Unix time that is commonly used in operating systems and programs that timestamp transactions as they happen. The reason Unix time is used is that no matter where you live or the time zone you are in, this Unix timestamp represents a moment that is the same everywhere.
Unix time is the duration in seconds or milliseconds from midnight of the 1st of January 1970 in UCT time. It is represented by a 32-bit integer that can be positive or negative.
Converting Unix time to Excel Time, first we will look at the formula when the timestamp is in second, and then we will look at the formula when the timestamp is in milliseconds.
Unix Timestamp | Excel Formula UTC & Time Zone CST | Number Result | Date Time UTC & CST Using format Cell (m/d/yyyy h:mm:ss) |
1657758939027.0293 | = Cell / 86400000 + 25569
= Cell / 86400000 + 25569 – 6/24 |
44756.02476
|
7/14/2022 0:35:39
7/13/2022 18:35:39 (GMT-6)
|
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article