select sum(hh),sum(substr(mi,1,instr(mi,'分钟')-1)) from (select nvl(substr(you_col,1,instr(you_col,'小时')-1),0) hh, nvl(substr(you_col,instr(you_col,'时')+1),0) mi from you_table) SQL code:
with a as (select '9小时20分钟' you_col from dual union all select '2小时20分钟' you_col from dual union all select '55分钟' you_col from dual)
select floor(sum(hh *60 + substr(mi,1,instr(mi,'分钟')-1))/60)||'小时'||(sum(hh *60 + substr(mi,1,instr(mi,'分钟')-1))/60-floor(sum(hh *60 + substr(mi,1,instr(mi,'分钟')-1))/60))*60 from (select nvl(substr(you_col,1,instr(you_col,'小时')-1),0) hh, nvl(substr(you_col,instr(you_col,'时')+1),0) mi from a)
