Colleague will be working on multiple queues per day.

Example, colleague is working 7 hours in queue, lets say he is in 1 queue all day that queue has 20/h target. so colleague in 7 hours has to action 140 and this would be my target 100% that he achieved.

But when i try to alter the formula to include more queue i'm getting error.

I've updated on dropbox if you can please download new version. and have a look at Colleague 2 and the formula in "Target"

Hope this makes sense