personnel performance scorecard

decided to try it this way , need some help with formula for total talk time colmn i can get the traffic light system to work in the ist cell but not the rest of the cells in column ?

also want to be able to do it on new sheet for month

for example
jan feb ect
name 1
name 2
ecct