SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

S7 Time in Excel

6/29/2012 4:44 PM	Rate (0)
Tuff Gong Posts: 41 Rating: (1)	I would like to display S7 time in Excel. I'm sending my data over via OPC. I can get my data in Excel, my problem is to display it as HH:mm:ss
Tuff Gong Posts: 41 Rating: (1)
Suggestion To thank Quote Answer

6/29/2012 5:18 PM	Rate (0)
hdhosseini Diamond Member Joined: 1/28/2009 Last visit: 3/8/2025 Posts: 6860 Rating: (1366)	Tuff Gong I would like to display S7 time in Excel. I'm sending my data over via OPC. I can get my data in Excel, my problem is to display it as HH:mm:ss Hello , I think the following topic would help you How do you specify the runtime for a timer via an operator panel, or how do you output the remaining runtime? Best regards Hamid Hosseini
	Demo Channel on Youtube
Suggestion To thank Quote Answer

6/29/2012 5:39 PM	Rate (0)
miami Platinum Member Joined: 8/31/2005 Last visit: 3/13/2025 Posts: 2198 Rating: (331)	You didn't wrote if the values you get make sens or not. And there is no S7Time. Do you mean a TIME ( e.g.T#1H1M) or S5TIME ( e.g. S5T#1M)? Here are the definitions: TIME holds the time in ms in a 32 signed integer value S5TIME i coded in BCD code, dsee attachment. It can be converted into TIME with the IEC function FC 33S5TI_TIM. You can find this function in the IEC libary in SIMATIC Manager. So you should be able to get it to excel in ms. How you can format it there I don't know. Attachment S5TIME Format.jpg (118 Downloads)

Suggestion To thank Quote Answer

Share this page:

Share this page on...