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?
Thanks
Can you check this answer , and modify accordingly?
https://answers.splunk.com/answers/620591/how-to-calculate-total-business-hours-in-between-w.html