excel中怎么求时间的平均数6:16:25:00.0000 7:08:13:00.0000 7:08:25:00.0000 7:08:25:00.0000 7:16:25:00.0000 7:16:20:00.0000 7:16:25:00.0000 7:16:25:00.0000 8:00:25:00.0000 8:00:20:00.0000 8:00:25:00.0000 8:00:00:00.0000 8:08:00:00.0000 8:07:55
来源：学生作业帮助网 编辑：六六作业网 时间：2025/02/02 17:39:52
excel中怎么求时间的平均数6:16:25:00.0000 7:08:13:00.0000 7:08:25:00.0000 7:08:25:00.0000 7:16:25:00.0000 7:16:20:00.0000 7:16:25:00.0000 7:16:25:00.0000 8:00:25:00.0000 8:00:20:00.0000 8:00:25:00.0000 8:00:00:00.0000 8:08:00:00.0000 8:07:55
excel中怎么求时间的平均数
6:16:25:00.0000
7:08:13:00.0000
7:08:25:00.0000
7:08:25:00.0000
7:16:25:00.0000
7:16:20:00.0000
7:16:25:00.0000
7:16:25:00.0000
8:00:25:00.0000
8:00:20:00.0000
8:00:25:00.0000
8:00:00:00.0000
8:08:00:00.0000
8:07:55:00.0000
8:08:00:00.0000
8:00:00:00.0000
8:08:00:00.0000
8:07:55:00.0000
8:08:00:00.0000
这组数据求平均数,（天：小时：分钟：秒钟：万分之一秒）
excel中怎么求时间的平均数6:16:25:00.0000 7:08:13:00.0000 7:08:25:00.0000 7:08:25:00.0000 7:16:25:00.0000 7:16:20:00.0000 7:16:25:00.0000 7:16:25:00.0000 8:00:25:00.0000 8:00:20:00.0000 8:00:25:00.0000 8:00:00:00.0000 8:08:00:00.0000 8:07:55
CTRL+SHIFT+ENTER完成公式
我个人只有这个笨办法,有兄弟提供了化简方案可是我不会,汗!
公式见附件,虽然得出了结果,但强烈建议用辅助列的形式计算,方便很多.