Countif or sumif when adding from a selection of a drop down and the range is in a different column

Hi Reddit,

I have a column for drop-down selection for machines and another one for time keeping. I'm trying to map out how long each machine is down for and use a pivot chart to make it visual. Any combinations of formulas I come up with come up broken.

Any advice is appreciated - even chart visual.

TYIA