i have to create a view of some pumps in my organization but i need your help as usual. basically, we have 2 pumps where they have to be running together all the time or stopped together. sometimes for unknown reasons one of them will be run and the other is stopped. i want to create a calculation where it calculate the time between them. meaning, if pump A is run and pump B is stop, and i just notice that. i want to know the total hours that was A running and B stopped.
hop you hear from you solution for this.