How do I calculate elapsed time between hours on two specific dates?

[jackreeves]

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

[nadlurinadluri]

Can you check this answer , and modify accordingly?

https://answers.splunk.com/answers/620591/how-to-calculate-total-business-hours-in-between-w.html