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
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/22 19:27:06
![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](/uploads/image/z/6966494-62-4.jpg?t=EXCEL%E6%97%B6%E9%97%B4%E6%B1%82%E5%92%8C%2C%E6%B1%82%E5%87%BA%E6%9D%A5%E6%80%BB%E6%98%AF00%EF%BC%9B00%EF%BC%9B00%E8%BF%9E%E6%8E%A5%E6%97%B6%E9%95%BF01%3A15%3A2100%3A04%3A3900%3A02%3A1500%3A27%3A0000%3A45%3A3701%3A09%3A3600%3A07%3A3900%3A21%3A4200%3A16%3A5800%3A09%3A1100%3A36%3A0000%3A03%3A5900%3A11%3A2900%3A05%3A3500%3A21%3A5601%3A04%3A2900%3A04%3A5100%3A01%3A4000%3A09%3A3000%3A07%3A0100%3A03%3A0000%3A07%3A2300%3A31%3A4700%3A55%3A410)
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
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
如果你的数据在A列用以下公式:
=TEXT(SUM(A:A),"[hh]:mm:ss")
如果还不行,输入:
=TEXT(SUM(--A:A),"[hh]:mm:ss")
同时按CTRL+SHIFT+ENTER结束输入即可