Unassigned time report SDP

Hi,

I need modify the next Query for MSSQL, SDP 8123:

SELECT woh1.WORKORDERID 'RequestID',dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (woh1.OPERATIONTIME/1000),'1970-01-01 00:00:00') 'Created Time',dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (woh2.OPERATIONTIME/1000),'1970-01-01 00:00:00') 'Assigned Time', convert(varchar,ROUND((((woh2.OPERATIONTIME-woh1.OPERATIONTIME)/1000)/3600),2)) +':'+ convert(varchar,ROUND(((((woh2.OPERATIONTIME-woh1.OPERATIONTIME)/1000)/60)) % 60,2)) 'UnAssigned Duration Hrs:Min',cat.categoryname 'Category',subcat.name 'Sub Category' FROM WorkOrderStates wos INNER JOIN WorkOrderHistory woh1 ON woh1.workorderid=wos.workorderid INNER JOIN WorkOrderHistory woh2 ON woh1.WORKORDERID=woh2.WORKORDERID LEFT JOIN SubCategoryDefinition subcat ON wos.subcategoryid=subcat.subcategoryid LEFT JOIN CategoryDefinition cat ON wos.categoryid=cat.categoryid WHERE woh1.OPERATION = 'CREATE' and woh2.OPERATION ='ASSIGN' AND woh1.OPERATIONTIME < woh2.OPERATIONTIME

I need make filter by Group Name and Date Range.

also need the hours and minutes appear according to service business hours ( not chronological )

Example: Monday to Friday from 8:30 AM to 06:00 PM

1 day = 09 hours and 30 minutes

Thans a lot!!

Mauricio Fuentes