EXCEL时间求和,求出来总是00；00；00

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/26 20:52:27

EXCEL时间求和,求出来总是00；00；00
连接时长
01:15:21
00:04:39
00:02:15
00:27:00
00:45:37
01:09:36
00:07:39
00:21:42
00:16:58
00:09:11
00:36:00
00:03:59
00:11:29
00:05:35
00:21:56
01:04:29
00:04:51
00:01:40
00:09:30
00:07:01
00:03:00
00:07:23
00:31:47
00:55:41
00:02:08
00:26:57
00:30:26
00:04:48
00:21:18
00:01:55
00:00:59
00:18:44
00:21:49
00:17:37
00:01:16
01:08:13
00:19:18
00:01:41
00:19:10
00:06:17
01:48:47
01:07:04
02:07:38
00:13:14
00:02:06
00:45:01
00:09:04
00:03:08
00:15:16
00:02:09
00:34:04
00:40:27
00:01:30
00:07:04
00:15:32
00:11:01
00:01:47
00:23:59
00:07:29
00:27:22
00:03:38
00:02:52
00:34:39
00:12:40
00:12:01
00:02:19
00:11:36
00:03:19
00:06:53
00:05:59
00:14:02
00:11:40
00:06:39
00:07:59
00:03:57
00:00:15
00:11:16
00:03:19
00:20:47
00:03:19
01:15:50
00:18:15
00:17:20
00:07:08
00:09:06
00:13:36
00:00:48
00:02:11
00:00:07
00:00:48
00:11:36
00:24:24
00:01:01
00:02:15
00:03:39
00:02:39
00:02:00
00:06:00
00:13:20
00:07:20
00:05:20
00:08:40
00:08:00
00:08:21
00:13:20
00:03:20
00:29:40
00:10:52
00:09:00
00:08:19
00:06:00
00:08:17
00:04:20
00:09:39
00:01:59
00:04:41
00:13:59
01:40:02
00:11:59
00:03:59
00:05:20
00:09:20
00:01:48
00:04:40
00:02:40
00:12:01
00:04:00
00:52:20
00:13:20
00:02:42
00:02:59
0:00:00

如果你的数据在A列用以下公式:
=TEXT(SUM(A:A),"[hh]:mm:ss")
如果还不行,输入:
=TEXT(SUM(--A:A),"[hh]:mm:ss")
同时按CTRL+SHIFT+ENTER结束输入即可

excel 时间求和00:44:4001:45:4300:43:0501:41:4302:47:2200:35:3202 这组时间怎么用EXCEL求和?01:18:54 00:03:10 00:30:13 00:02:28 00:34:33 EXCEL角度求和公式?如A1：0°00′01″,B1：100°10′10″ excel求和等于0excel求和总是等于0,这是怎么回事?那怎么一次把文本的全部都改成数值格式? excel如何有条件求和? EXCEL求和函数问题 excel表格求和公式 excel表格求和公式 excel函数条件求和 Excel 函数条件求和如何用excel求和? EXCEL 两行两行求和公式