Report - How To Calculate Working Hours Only?
I am working on a report to show total time consumed since a ticket was openned until its closing.
Is there a way
to calculate this period on a select query or do I need to create some counter (custom fields) to sum the working hours?
My report is getting just the difference between created and closed (including all nonworking hours and holidays). But I need to consider only working hours.
I appreciate any comment about this.