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

    Formula error

      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,