This is a guide on how to translate the millisecond time stamp that is embedded in .csv in WinCC data log file using Open Office Calc.
Please note that this guide has been designed to cover any user level and therefore may contain elements deemed very basic by the advanced user.
The first thing to note is that this millisecond stamp is actually a date/time stamp that will originally include seconds, but may also be instructed to display milliseconds.
Using the file that was previously provided, the following will display a step-by-step method.
Open the file and navigate to Row 1.
Having opened the file, select the uppermost millisecond cell.
Click on the cell once in order to select it.
In the formula bar, add a decimal after the 5th digit and hit Enter.
The selected cell will now appear as follows.
With the cell again selected, click on Format, then Cells and the window below will appear.
Within this window, under Category select Time.
Now click in the Format code area in order to select it.
This is an example of what will be found in this area by default.
If yours is not the same, it does not matter.
Alter the code until it reads as follows:
In the sample display area, you will see the cell contents as they will be displayed with the code as you have entered.
Now click on OK
Your cell contents will now be displayed as follows.
END OF INSTRUCTION