Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share a sample to check out the issue?
Best,
Sunny
Hi Sunny,
Thanks for your help. I manage to solve the issue.
Thanks,
Hasvine