I am trying to develope an PE that will return a value that gives percent time that a value is good or with in limits. I want to create an 2 PE's. This first one would be to track the percent of time that a value is good from 6:30am to 6:30pm and then hold that last value until it resets at 6:30am. Then I would like the same PE for 6:30pm to 6:30am the next day.
The follow PE works correctly for a 24hour time period, but I can't seem to get it broke down into two time periods. This is the PE that I have for 24hour time period:
(IF HOUR('*') >= 7 AND MINUTE('*')>=0 THEN (TimeEq('3SBFLG','T 7H','*',"Sheet Up")/(DaySec('*')-25200)) ELSE (TimeEq('3SBFLG','Y 7H','*',"Sheet Up")/(DaySec('*') 61200)))*100
Any help would be appreciated