Another solution is:
DECLARE @tmp TABLE (ID INT IDENTITY(1,1), Value VARCHAR(10))
INSERT INTO @tmp (Value)
VALUES('10'),('20'),('30'),('9:15'),('10:15'),
('8:10'),('9:15'),('40'),('50')
SELECT DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', T1.TValue )), '00:00:00.000') AS SumOfTime
FROM (
SELECT ID, Value AS TValue
FROM @tmp
WHERE CHARINDEX(':', Value)>0
) AS T1
SELECT SUM(CONVERT(INT,T2.IValue)) AS SumOfInt
FROM (
SELECT ID, Value AS IValue
FROM @tmp
WHERE CHARINDEX(':', Value)=0
) AS T2
Results:
SumOfTime
1900-01-02 12:55:00.000 - it means 2 days and 12 hrs 55 mins
SumOfInt
150