Virtually the same formula
= SUMIFS( values, timeJobs, ">=" & timeReport, timeJobs, "<" & timeReport+halfHour )
except that, instead of 'copy down', I use absolute references and an array formula.
It works brilliantly with dynamic arrays (the formula is in a single cell and sizes to match the references without further user intervention); somewhat 'clunky' with CSE arrays.