Formula error

[#1]

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

[sunny_talwar]

Would you be able to share a sample to check out the issue?

Best,

Sunny

[#3]

Hi Sunny,

Thanks for your help. I manage to solve the issue.

Thanks,

Hasvine