Excel: calculate efficiency from times

[McGraw]

Good morning.

I’ve completely removed my initial query and replaced it with this one:

I want to conditionally format cells so 0% is bright red, 100% is normal green. Anything inbetween graduates from red to green and above 100% the green gets brighter to a max of say 200%.

Any ideas? Thank you