sql - Adding all Time values in a column -

sql - Adding all Time values in a column -

i have next data

shift_working_hours -------------------- 03:45 09:00 08:45 07:50

i want add together values in shift_working_hours column , want result 28:40. please guide me how can using sql. using toad.

-- if string column select convert(varchar,sum(convert(int,parsename(replace(wh,':',''),2) +(sum(convert(int,parsename(replace(wh,':',''),1)/60))+':' +convert(varchar,(sum(convert(int,parsename(replace(wh,':',''),2)%60)) table -- if datecolumn select convert(varchar,sum(datepart(hh,wh))+ sum(datepart(mm,wh))/60)+':'+ convert(varchar,sum(datepart(mm,wh))%60)

sql time add toad