the hours of operation of two device

Hello, I have also attached an excel form where the hours of operation of two pumps are filled in (with several examples of completion). I am interested in how I can calculate the idle hours per day depending on the operation of the two pumps, which represents the interval in which I did not consume energy from the system. Thanks