怎么在EXCEL表格编辑算时间公式?答:I13格输入 =SUMPRODUCT(LEFT(I7:I12,FIND("小时",I7:I12)-1)*1)+ROUNDDOWN(SUMPRODUCT(SUBSTITUTE(RIGHT(I7:I12,LEN(I7:I12)-FIND("时",I7:I12)),"分","")*1)/60,0)&"小时"&MOD(SUMPRODUCT(SUBSTITUTE(RIGHT(I7:I12,LEN(I7:I12)-FIND("时",I7:I12)),"分","")...