I have an Incident "Open Date" in following format DD/MM/YYYY HH:MM and an Incident "Close Date" in same format.
I want to calculate the amount of time between the two dates. However, I only want to calculate the hours between 09:00 and 17:00 on those dates.
Can any one advise?
Can you check this answer , and modify accordingly?