这组时间怎么用EXCEL求和?01:18:54 00:03:10 00:30:13 00:02:28 00:34:33 00:44:30 00:05:50 00:08:57 0000:50:1000:14:1800:08:2600:24:3100:02:3200:06:0801:22:0300:38:3000:09:2300:23:1001:35:2700:21:2600:33:4700:14:4400:38:3000:44:0801:22:0201:27:3

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/13 07:08:58
这组时间怎么用EXCEL求和?01:18:54 00:03:10 00:30:13 00:02:28 00:34:33 00:44:30 00:05:50 00:08:57 0000:50:1000:14:1800:08:2600:24:3100:02:3200:06:0801:22:0300:38:3000:09:2300:23:1001:35:2700:21:2600:33:4700:14:4400:38:3000:44:0801:22:0201:27:3

这组时间怎么用EXCEL求和?01:18:54 00:03:10 00:30:13 00:02:28 00:34:33 00:44:30 00:05:50 00:08:57 0000:50:1000:14:1800:08:2600:24:3100:02:3200:06:0801:22:0300:38:3000:09:2300:23:1001:35:2700:21:2600:33:4700:14:4400:38:3000:44:0801:22:0201:27:3
这组时间怎么用EXCEL求和?01:18:54 00:03:10 00:30:13 00:02:28 00:34:33 00:44:30 00:05:50 00:08:57 00
00:50:10
00:14:18
00:08:26
00:24:31
00:02:32
00:06:08
01:22:03
00:38:30
00:09:23
00:23:10
01:35:27
00:21:26
00:33:47
00:14:44
00:38:30
00:44:08
01:22:02
01:27:30
00:14:19
00:13:35
00:02:38
00:06:07
00:06:15
00:59:57
00:34:20
我怎么用你们的方法输出全是0:00:00呢
我估计是00.00.00格式不对,应该0.00.00格式才对

这组时间怎么用EXCEL求和?01:18:54 00:03:10 00:30:13 00:02:28 00:34:33 00:44:30 00:05:50 00:08:57 0000:50:1000:14:1800:08:2600:24:3100:02:3200:06:0801:22:0300:38:3000:09:2300:23:1001:35:2700:21:2600:33:4700:14:4400:38:3000:44:0801:22:0201:27:3
=TEXT(SUM(A1:A96),"[h]:mm:ss")
结果为:
52:52:23