11 Replies Latest reply: Jun 8, 2015 2:25 AM by Hasvine Dhurmea RSS

    Formula error

    Hasvine Dhurmea

      Hello All,

       

      I am having an issue in writing a formula.

       

      Could you please help:

       

      If([Résolution Time] > Interval#('4', 'hh')and([Résolution Time] < Interval#('10', 'hh')),Interval#('10', 'hh')) - Interval#('4', 'hh'),0)

       

      I think I am not doing it correctly.

       

      Actually i need a formula which states that if the [Résolution Time] is more than 4 hours and less 10 hours, it show as 6 hours in my Excess field and if [Résolution Time] is less than 4 hours it shows as 0.

       

      Many thanks for your usual help.

       

      Kind Regards,

       

      Hasvine