Need formula for productivity calculation

Hi

With your data I can not understand what you really want. Where are the data to 'Start time' and 'Finish time'?

Analyze the results that I calculated and use your data to write, in Sheet3, what you really wanted to find.

In E5: E11 I determined counts with

Formula:

=COUNTIFS($A$17:$A$25,$A5,$B$17:$B$25,E$4)

To calculate the time spent use in J5 the following formula

Formula:

=INDEX(MMULT(E5:H5,'Time Frame'!$B$2:$B$5),0)

See the file