Selected Answer
I made the following changes to your workbook.
- I inserted a named range, name "Times", to cover $C$16:$C$3476
- I inserted a named range, name "Users", to cover $E$16:$E$3476
- And a third named range, name "Durations", in $J$16:$J$3476
For these 3 ranges you should find a formula to change row 3476 automatically when the worksheet expands or contracts. That is scope of another question.
- I inserted the formula [J2] =E68.
You may like to have this necessary information in another cell, certainly get it there by another means, but that is scope for yet another question.
Now you can uses the following two formulas.
[M2] =COUNTIFS(Times,">="&$K2,Times,"<"&$L2,Users,$J$2)
and
[N2] =SUMIFS(Durations,Times,">="&$K2,Times,"<"&$L2,Users,$J$2)
Copy down to M12:N12 and be sure to format column N as Time.