如下图:
1)如果上述时间不是日期型的,按下图中B1中公式:
=TIMEVALUE(IF(ISERROR(FIND("时",A1)),IF(ISERROR(FIND("分",A1)),"0:0:"&SUBSTITUTE(A1,"秒",""),"0:"&SUBSTITUTE(SUBSTITUTE(A1,"秒",""),"分",":")),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"秒",""),"分",":"),"时",":")))
转换为日期型的
2)选中单元格,右键->设置单元格格式->自定义,[h]"时"m"分"s"秒"
3)转换为日期型后,就可以直接做加法了,如下图中B8中公式:=SUM(B1:B7)