Convert Varchar Duration time to time
Assuming the format in the 2 columns is hours:mm:ss[.fff] where hours can be even more than 24, I think this would work:  

SELECT smf.* 
FROM [SMF_DATA].[dbo].[System_Management_Facility] AS smf
  CROSS APPLY
    ( SELECT CHARINDEX(':', CPUTM)    AS i1, 
             CHARINDEX(':', CPUZIPTM) AS i2,
             LEN(CPUTM)    AS len1,
             LEN(CPUZIPTM) AS len2
    ) AS a
  CROSS APPLY
    ( SELECT CONVERT(int, LEFT(CPUTM, i1-1))
             + CONVERT(int, LEFT(CPUZIPTM, i2-1)) AS number_of_hours,
             CONVERT(datetime, '00:' + RIGHT(CPUTM,    len1-i1)) AS d1,  -- implicit 
             CONVERT(datetime, '00:' + RIGHT(CPUZIPTM, len2-i2)) AS d2   -- dates
                              -- both d1 and d2 get implicit date of '1900-01-01'
    ) AS b
WHERE 
    number_of_hours + DATEDIFF(hour, '19000101', d1 + d2) &gt;= 2 ;


The CROSS APPLY are not really needed, they are there so the logic is split in parts and so you don't have a huge complicated final condition.



If you wanted a different check (say 10 minutes instead of 2 hours), it would need only this change:

WHERE 
    number_of_hours = 0
  AND
    DATEDIFF(minute, '19000101', d1 + d2) &gt;= 10 ;