EXCEL 几分几秒几几如何算和、平均值?

平均：=ROUND(AVERAGE(IF(ISERR(TEXT(TIME(0,LEFt(A1:A100,FIND("分",A1:A100)-1),MId(A1:A100,FIND("分",A1:A100)+1,FIND("秒",A1:A100)-FIND("分",A1:A100)-1)),"[ss]")+(RIGHt(A1:A100,LEN(A1:A100)-FIND("秒",A1:A100)))/100),"",TEXT(TIME(0,LEFt(A1:A100,FIND("分",A1:A100)-1),MId(A1:A100,FIND("分",A1:A100)+1,FIND("秒",A1:A100)-FIND("分",A1:A100)-1)),"[ss]")+(RIGHt(A1:A100,LEN(A1:A100)-FIND("秒",A1:A100)))/100)),2)&"秒"求和：=ROUND(SUM(IF(ISERR(TEXT(TIME(0,LEFt(A1:A100,FIND("分",A1:A100)-1),MId(A1:A100,FIND("分",A1:A100)+1,FIND("秒",A1:A100)-FIND("分",A1:A100)-1)),"[ss]")+(RIGHt(A1:A100,LEN(A1:A100)-FIND("秒",A1:A100)))/100),"",TEXT(TIME(0,LEFt(A1:A100,FIND("分",A1:A100)-1),MId(A1:A100,FIND("分",A1:A100)+1,FIND("秒",A1:A100)-FIND("分",A1:A100)-1)),"[ss]")+(RIGHt(A1:A100,LEN(A1:A100)-FIND("秒",A1:A100)))/100)),2)&"秒"以上两个公式随便在空的单元格中输入,前提都是你的数据是在A1:A100,而且,输入这个公式后要同时按CTRL+SHIFT+ENTER才有效。 刚刚求和搞错了