First of all, I would like to give you suggestion to use time format as HH:MM:SS, for example 2:12:33 where it means 2 hours 12 mins and 33 seconds. And even if you have just 45 seconds then use 0:00:45.
It would be easy for you to have calculation on it in your spreadsheet.
So now, I have converted your spreadsheet in HH:MM:SS format. Have a look at screenshot below:
Now to get the sum in Cell B11, put the following formula in it:
And now to compare it will Cell B12 and B13, put the following formula in Cell B15:
=if(and(B11>=B12,B11<=B13);"OK!";if(B11<B12;"Under By:";"Over By:"))
the above formula will show you whether difference is "OK!" or "Under By" or "Over By"
And put the following formula in Cell B16:
the above formula will show you the difference.
Now, to change the color as per your requirement, click on the Cell B15 and then select "Format" >> "Conditional formatting...". Have a look at the screenshot below:
Now in Conditional formatting window, put "OK!" in text box near "Text contains" and then change background color to green and then click on "Add another rule" and put "Over By:" and select background color as red, again add another rule and put"Under By:" and then put background color as red, and then click on "Save rules". Have a look at the screenshots below:
Screenshot of conditional formatting window:
So now you are done with formula and formatting with Cell B15 and B16. Now you can simply select these both cells and copy (ctrl C) and paste on Cell E15 and E16 then again paste it on Cell H15 and H16 and so on...
So this will quickly paste the formula and formatting on these cells..
Have a look at the final screenshot of the revised spreadsheet:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.