Here is the query for the report without hours in between. Im wondering if you could help me add the last bit to report between those set of hours.

SELECT "ti"."FIRST_NAME" AS "Technician", "std"."STATUSNAME" AS "Request Status", "wo"."CREATEDTIME" AS "Created Time", "mdd"."MODENAME" AS "Request Mode", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS "Department", "ti"."FIRST_NAME" AS "Technician"  FROM "WorkOrder" "wo" LEFT JOIN "ModeDefinition" "mdd" ON "wo"."MODEID"="mdd"."MODEID" LEFT JOIN "SDUser" "sdu" ON "wo"."REQUESTERID"="sdu"."USERID" LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" LEFT JOIN "DepartmentDefinition" "dpt" ON "wo"."DEPTID"="dpt"."DEPTID" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "SDUser" "td" ON "wos"."OWNERID"="td"."USERID" LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" WHERE  (((("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Closed') OR ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Resolved')) AND ((("ti"."FIRST_NAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Rohit Nagi') OR ("ti"."FIRST_NAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Thomas Hayward')) OR ("ti"."FIRST_NAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Trevor Cooper'))) AND ((("wo"."RESOLVEDTIME" >= 1488355200000) AND (("wo"."RESOLVEDTIME" != 0) AND ("wo"."RESOLVEDTIME" IS NOT NULL))) AND (("wo"."RESOLVEDTIME" <= 1491029999000) AND ((("wo"."RESOLVEDTIME" != 0) AND ("wo"."RESOLVEDTIME" IS NOT NULL)) AND ("wo"."RESOLVEDTIME" != -1)))))  AND wo.ISPARENT='1' AND wo.IS_CATALOG_TEMPLATE='0'  ORDER BY 1, 3

Thank you very much