wincc flex time_ms to human time/date

[apetkov5]

Hi all,

is there any easy way (in ms excel or so) to translate value that is automatically writen in "time_ms" at wincc flexible archieve - to human readable date/time...

so, i got rdb file wheare form i exported table with datas do csv. after that i imported csv to excel and get no lucky by dividing value wint 1000000 and changeing format cels to date.
also by folowing standard unix time converters i did not get result.

is there any catch?

br

 

[gclshortt]

https://support.industry.siemens.com/tf/ww/en/posts/time-ms-in-wincc-flex-alarm-logging/36329/?page=0&pageSize=10

It looks like you are on the right approach.
Can you post the actual number and what you expect it to translate into?

Regards,

 

[JesperMP]

The problem may be that Excel formats the value already when you open the CSV file.
Open the CSV file as a text file, then copy the time_ms value and post it here.

 

[apetkov5]

The problem may be that Excel formats the value already when you open the CSV file.
Open the CSV file as a text file, then copy the time_ms value and post it here.

hello,

when i do that, i get this:

Time_ms 421.854.868.201.042 421.866.082.271.528 421.866.129.679.282 421.866.170.319.097 421.866.190.651.505 421.866.325.143.634 421.866.366.128.241 421.866.373.303.125 42.189.838.595.544 421.898.848.794.097 421.899.265.484.606 421.899.682.175.116 421.900.098.865.509 421.900.515.556.019 421.900.932.251.157

 

[JesperMP]

Remove the periods. Maybe you have set the period as a decimal group character.
So 421.854.868.201.042 becomes 421854868201042.
Then specify to display with date/time format.

 

[apetkov5]

Remove the periods. Maybe you have set the period as a decimal group character.
So 421.854.868.201.042 becomes 421854868201042.
Then specify to display with date/time format.

done!

i make "by hand" 421854868201042 to be 4218548682.0104, then divide that value by 1000000 and then change format cell to date.

thanx!