Calculate time A program or job has ran | Factory Talk View

[cschlue]

None taken, when I first saw the touch panel applications I asked why the PMC's couldn't just track it (albeit like I said I'm not familiar with plc's or pmcs and 3 weeks ago I was an IT Administrator for a smaller company and had not even heard of either.)

I think it may have been more of an issue of them not knowing how to calculate how long a job has ran or the elapsed time. But I'm only guessing.

 

[Ken Roach]

The hard part was making sure my expression to convert a number of Elapsed Seconds into Hours, Minutes, and Seconds was correct. Rounding is easy on paper but tricky on computers.

In the FactoryTalk expression language, the Modulo operator is "%". The expressions I used are:


Seconds Expression:

({system\DateAndTimeInteger} - {Event_1_Timestamp})% 60


Minutes Expression:

If (({system\DateAndTimeInteger} - {Event_1_Timestamp})% 60) >= 30 then ((({system\DateAndTimeInteger} - {Event_1_Timestamp}) % 3600) / 60) - 1
else ((({system\DateAndTimeInteger} - {Event_1_Timestamp}) % 3600) / 60)


Hours Expression:

If (({system\DateAndTimeInteger} - {Event_1_Timestamp}) % 3600) >= 1800 then ((({system\DateAndTimeInteger} - {Event_1_Timestamp}) / 3600) - 1)
else (({system\DateAndTimeInteger} - {Event_1_Timestamp}) / 3600)

 

[Ken Roach]

Here's the one-screen example application. There is one Macro and one Macro button, and everything else is calculated in the Expressions for the Numeric Indicators.

The attached file is a FactoryTalk View Archive (*.APA) file ZIPPED for posting on the Forum. Unzip it then run the FactoryTalk Application Manager utility to "Restore" it, which will make it an openable FTView ME application on your FTView Studio computer. It was created and saved in FactoryTalk View version 7.0.

 

[cschlue]

Looks great Ken, Glad to see there was a better way to do it. (outside of actually using the pmc to track it obviously)

And it looks like your solution actually sets me up perfectly for figuring out how to do a split timer as well

ie: Store IDLE Time, ARC time and Total Elapsed Time.

Again your help has been greatly appreciated!