Formula for employee utilization

[JohnnyRocketSeed]

Good day

I am trying to figure out a formula to calculate employment utilization based on the following scenario/data set.

Bob and Steve work in a café 2 hours per day (Monday through Friday) selling hot dogs, hamburgers, fries and lasagna. It takes 5 minutes to deliver a hot dog, 10 for a hamburger, 5 for fries and 10 for lasagna. I would like to be able to filter on a date (either a specific day, or a month) and calculate the employment utilization (time spent working vs time spent at work) as a percentage out of 100 for each employee.

 

[BSALV]

add a 4th column in which with vlookup, you add the time and then you can make a pivottable of it.
For better help, you can add an example with the XL2BB-tool (see ribbon above)