This content has been marked as final. Show 11 replies
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.