EXCEL 几分几秒几几如何算和、平均值?例如：1分18秒222分17秒331分20秒11如何计算平

答案:2 悬赏:0 手机版

解决时间 2021-02-06 22:22

提问者网友：浮克旳回音
2021-02-06 11:10

最佳答案

五星知识达人网友：刀戟声无边
2021-02-06 11:36

平均：=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才有效. 刚刚求和搞错了

全部回答

1楼网友：末日狂欢
2021-02-06 12:25

正好我需要

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息