早教吧作业答案频道 -->其他-->
EXCEL时间求和,求出来总是00；00；00连接时长01:15:2100:04:3900:02:1500:27:0000:45:3701:09:3600:07:3900:21:4200:16:5800:09:1100:36:0000:03:5900:11:2900:05:3500:21:5601:04:2900:04:5100:01:4000:09:3000:07:0100:03:0000:07:2300:31:4700:55:410
题目详情
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
连接时长
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结束输入即可
=TEXT(SUM(A:A),"[hh]:mm:ss")
如果还不行,输入:
=TEXT(SUM(--A:A),"[hh]:mm:ss")
同时按CTRL+SHIFT+ENTER结束输入即可
看了 EXCEL时间求和,求出来总...的网友还看了以下：
甲、乙、丙三车间加工同一件产品,加工量分别占总量的25%、35%、40%,次品率分别为0.03、0 2020-05-17 …
控辍保学的目标使初中学生辍学率控制在()左右A.0B.0.03%C.0.02%D.0.01% 2020-05-31 …
将2mol的so2和1mol的02加入到1L的密闭容器中,测得so2的浓度为0.6mol/l,求0 2020-06-05 …
宏观经济学：黄金律是指什么，黄金律对应的人均资本量是什么意思？8.在新古典增长模型中，人均生产函数 2020-06-19 …
同比03年上半年,商品房平均销售价格为2424/平方米,同比增长5.4%,而去年同期是下降0.1% 2020-07-21 …
EXCEL时间求和,求出来总是00；00；00连接时长01:15:2100:04:3900:02: 2020-07-21 …
某基坑底长80m,宽60m,深8m,四边放坡,边坡坡度1:0.5如地下室的外围尺寸为78m×58m 2020-07-30 …
设函数f(x)=(x-a)e∧x+(a-1)x+aa属于Re为自然对数底数1.a=1时,求fx单调 2020-08-02 …
1、已知e^5-3x=e^2(y+2),ln(4x-y)=4ln2,求x,y的值.2、解方程4x^3 2020-11-01 …
excel有没有表示单和双行的函数已知下列数据（从第一行开始）：ABCDEF4,31,11,13,0 2020-12-08 …