After doing a cleaning of one equipment, in an aseptic system, it requires to flush it with steam to sterilize it for 10 minutes, if the time is higher than 10 minutes, then that time (the differential) is considered as an anomaly or waste of energy. If I create a Value Based Search it detects all the events with highest duration of 10 minutes, but I can’t consider the whole time detected, to be considered as a waste it has to last more than 10 minutes, therefore the time detected requires a subtraction of 10 minutes in the duration.
Is there any function in a formula to create a conditional based in time duration to create a soft-sensor, something like
if Sterilization step > 10 minutes then 1, otherwise, 0