Hi

Firstly

You do not need to use the Value() in the time formula.
It works just as well without.

=IF(G2<H2,"Breached",G2-H2)

Secondly

Unless you have a 3rd logic eg Low, Medium & High ( of which you only
use Low/Medium), you will only need to do this:

=IF(C2="Medium",WORKDAY(E2,3)+E2-INT(E2),WORKDAY(E2,5)+E2-INT(E2))

And Lastly

In the format screen, select Custom and copy this in

d "Days", hh:mm:ss

It will display 5 Days, 10:20:20

HTH
Mick.

ok

Rule 1. =I1="Breached"
Rule 2. =I1<=0.375
Rule 3. =IF(I1<=0.625,AND(I1>0.375))
Rule 4. =IF(I1<=1.25,AND(I1>0.625))
Rule 5. =I1>1.25

HTH
Mick.