I have the following query, but I want to know if there is any field that indicates the business hours between the EXECUTEDTIME and ENDTIME for each state. The data shown in the image:

SELECT

    wo.WORKORDERID AS "Request ID",

    rtl.TEMPLATENAME AS "Nombre de la plantilla",

    longtodate(woa.EXECUTEDTIME) AS "Inicio de estado",

    longtodate(wsi.ENDTIME) AS "Cambio de estado", 

    wsiSd.STATUSNAME AS "Estado",

    longtodate(wo.CREATEDTIME) AS "Hora de creacion",

    longtodate(wo.RESOLVEDTIME) AS "Hora de resolucion",

    longtodate(wo.COMPLETEDTIME) AS "Hora de cierre",

    std.STATUSNAME AS "Status actual"

FROM WorkOrder wo 

LEFT JOIN WO_Assessment woa

    ON wo.WORKORDERID = woa.WORKORDERID 

INNER JOIN WO_Status_Info wsi

    ON woa.ASSESSMENTID = wsi.ASSESSMENTID 

LEFT JOIN StatusDefinition wsiSd

    ON wsi.STATUSID = wsiSd.STATUSID 

LEFT JOIN WorkOrderStates wos

    ON wo.WORKORDERID = wos.WORKORDERID 

LEFT JOIN StatusDefinition std

    ON wos.STATUSID = std.STATUSID

LEFT JOIN RequestTemplate_List rtl

    ON wo.TEMPLATEID = rtl.TEMPLATEID

WHERE 

    wo.CREATEDTIME BETWEEN <from_thisyear> AND <to_thisyear>

    AND rtl.TEMPLATENAME = 'Solicitud de Iniciativa'

    AND std.STATUSNAME IN ('Resuelto', 'Cerrado') 

    AND wo.ISPARENT = '1';