I created a report who calculate the time of incident from Open to Resolve.
the report is working fine but now the customer have a below queries which need to be address:
1- Report should calculate business hours only.
2- weekend time should not be calculated in report.
If Incident open on Thursday@ 10:00 AM (Last working day) and close on Sunday(First Working day) 10:00 AM
then the report should show the total time 9 hours instead of 64 hours.
any idea how can we create the query.