I am working on calculating machine uptime and downtime through VBA programming in PI Processbook.
I have a PI tag with number of filled containers. I have start and end datetime for machine runtime.
Logic is simple: As long as # of containers are rising, machine is running and duration is counted as uptime.
If any events occur during this period because of machine stops momentarily (few min to few hours), than this duration is considered downtime.
I want to calculate accumulative uptime and downtime.