3/16/2020 1:16 PM | |
Posts: 20 Rating: (0) |
I want to convert Dword integer value (HHmmss) to time format ( HH:mm:ss). For example 32448 -----> 3:24:48 175342 -------> 17:53:42 Date: 101120 ------> 10/11/20 50720 -----> 5/07/20 Could you help me? ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 03/17/2020 06:36:31New subject after splitting |
|
3/17/2020 8:43 AM | |
Joined: 5/16/2014 Last visit: 9/12/2022 Posts: 7298 Rating: (2164)
|
Hello ali.riazati, the datatype "Date/Time" which is available in WinCC since V7.3 see for more information https://docs.microsoft.com/de-de/office/vba/access/concepts/date-time/calculate-elapsed-time Regards Georg Berghof |
PS: If this post did really help you, you may use the Rate-button |
|
3/17/2020 10:48 AM | |
Posts: 20 Rating: (0) |
Thank you for your answer. I Read time from modbus devices with this format " HHmmss , float value " It is not clear for people. How i can show it in this shape" HH:mm:ss" I convert the value to string. Could you tell me wich script could get string character and after that i use script to add : or / between them in C script function. I need script that get HH , mm , ss After that i need script that concatenate them with : or /. HH + : + mm + ss |
3/17/2020 10:14 PM | |
Joined: 11/17/2015 Last visit: 8/13/2024 Posts: 57 Rating: (16) |
Hi. What HMI and PLC do you have? Solution depends on it |
4/4/2024 10:59 AM | |
Joined: 2/6/2009 Last visit: 6/10/2024 Posts: 46 Rating: (23) |
If it is, as you said, format val = HHmmss (but i dont see float here, just INT) you could use combination of mod and div function to get particles and with little math to get separate numbers.
i.e. If you are more comfortable with string functions you could use them to extract left, middle and right portion of val string into separate strings with string functions. Even if you have INT with number of seconds you could use mod and div with 60, 3600, 86400 etc to "extract" number of days, hour, minutes and seconds. Maybe this tread can help. BR, VladD |
Follow us on