I need to determine the number of hours a machine is down. The counter should subtract the Work order Start time from either System Up Time status or Completed work order status time. The problem is the machine may have the System Up Time status and Completed work order status in the same work order.
Each work order may have multiple statuses, i.e. Open, In progress, In progress, System Up Time status, Completed work order status .
Can someone assist?