Time Subtraction with condition

[lovinguy]

Hi!


I am looking for a formula to subtract time and if it is less than the required 9 hours then it should give value otherwise displays zero.

For examples 18:54 - 10:04 = 8:50min so I need value 00:10 (i.e 10 min short of 9 hours)

For example 18:00 - 9:59 = 0 (i.e Value 0 as it is more than 9 hours)


Thanks in advance

[zbor]

How about this:

="09:00" - MIN(C2-D2, "09:00")