Hi,
I need report with average assigned time (between create time and assigned time) and average resolved time (between assigned time and resolved time) per Technican / Month.

The first problem is with find resolved time. I have only closed time and it is not the same. If the SDP has no resolved time it can be cost register time (last if ticket has more than one register time).

The second problem is with working hours. The average assigned time is time between create time and assigned time minus holiday hours.

I have MSSQL

I'll be very grateful for any suggestions

Marcin