DECLARE @YA AS DATETIME = GETDATE() select *, timefromparts(m / 60, m % 60, 0, 0, 0) as [hours worked] from Datos.dbo.RegistroDeEntradas cross apply (values (datediff(minute, cast( isnull(nullif([HORA DE ENTRADA], ''), [RETARDO]) as time), cast([HORA DE SALIDA] as time)))) M(m) where DATEPART(ISO_WEEK, @YA) = NoSem ORDER BY Fecha, [HORA DE ENTRADA] DESC;