Comparison operator with duration that may exceed 1 day with format h mm

Question

I have an excel spreadsheet that tracks duration, which can range from 0:00 (h:mm) to d:h:mm (with number of days beyond 1). Up to column T, "Respect Délai," everything goes according to plan. Here, I want to determine whether the deadline (délai) is honored using the following formula:

 =IF(OR(AND(S2="1:00",D2="Imagerie Conventionnelle"),AND(S2="5:00",D2="Imagerie lourde")),"Oui","Non") 

where column D denotes a binary kind of imagery (must remain the same) and D denotes a duration in the format h: mm (that sometimes goes beyond 23:59). The formula appears to work for most of the rows, but for others, it returns the wrong answer based on the IF conditions (I manually confirmed them), and I'm not sure why.

Please note that I tried to use the TIME(h,,) instead of "h:mm" but since it only accepts values between 0:00 and 23:59, this doesn't seem to work either.

Answer 1

Try this:

=IF(OR(AND(S2<=0.0417,D2="Imagerie Conventionnelle"),AND(S2<=0.2083,D2="Imagerie lourde")),"Oui","Non")