问题描述
我在Excel表中有几列，我需要做一个总结。单元格包含以下格式的数据： hh：mm 。
I have few columns in an excel sheet for which I need to do a summation. The cell contains data in this format: hh:mm.
我需要下面的单元格中的求和。我无法确定如何格式化单元格以及在公式中写入的内容！
I need the summation in the cell below them. I'm not able to identify how should I format the cells and what to write in the formula!
我有MSEXCEL 2007。
I have MSEXCEL 2007.
编辑：包含的数据。
说我有这么多数据（对不起看，请考虑下一个单元格的空格）：
Say I have this much data (Sorry looks weired, please consider spaces as next cell):
3:20
1:30
2:20
1:12
1:00
1:00
1:40
7:55
0:15
0:20
1:20
1:30
3:20
0:15
1:20
1:17
0:33
1:20
2:25
2:54
0:19
0:10
1:35
1:45
2:15
0:20
0:45
0 ：17
4:47
3:00
1:00
5:30
0:30
0:05
1： 50
4:05
2:18
1:15
3:05
0:30
0:10
3:00
0:45
3:00
5:05
6:00
1:20
2:20
0:13
0:20
5:20
5:20
0:20
0:09
6:55
0:20
3:11
2:30
7:00
7:00
0:20
0:14
8:46
0:15
5:10
0:20
0:25
2:05
0:10
3:17
2:59
0:25
1:35
0:15
1:05
0:35
1:55
2:40
0 ：30
2:05
0:20
0:17
3:20
1:15
4:30
1： 20
0:10
1:35
1:00
1:55
0:50
0:15
1:10
0:10
1:45
1:00
0:50
1:10
1:25
1:05
1:50
0:12
0:30
1:15
0:45
3:30
1:35
0:15
0:10
0:50
0:30
7:10
0:18
1:15
0:20
0:25
1:15
3:00
1:00
0:25
3:39
0:13
2:47
0:25
1:05
0:26
0:15
0:25
3 ：14
2:45
0:40
2:20
0:38
0:12
2:37
2： 03
6:55
0:18
4:30
0:10
1:00
3:45
2:40
0:10
0:29
1:18
0:50
0:56
5:44
0:14
0:30
0:15
1:00
5:25
2:05
0:55
0:09
4:05
0:35
0:30
0:10
0:15
3:08
2:53
2:43
0:31
1:25
0:10
1:43
1:00
1:20
1:20
0:15
1:30
5:05
2:55
0:20
0:10
4 ：25
2:40
0:08
0:13
0:12
9:50
0:15
0： 25
0:10
4:30
0:35
0:15
0:10
1:20
1:00
3:09
2:41
7:34
0:11
1:05
0:20
0:10
1:59
0:20
2:02
0:38
0:35
2:15
0:22
0:12
4:37
0:35
2:10
0:10
1:54
2:50
0:40
3:12
0:09
0:09
1:21
0:35
3:30
3:00
0:25
0:29
0:16
7:21
0:05
4:52
2 ：30
0:45
0:25
0:40
0:20
3:48
0:37
2： 53
0:15
0:50
1:40
0:13
2:11
1:30
0:50
0:38
0:05
1:55
0:39
2:02
0:43
1:56
0:10
0:15
4:29
0:40
0:35
0:15
0:44
2:17
0:14
0:08
3:09
0:49
0:58
2:21
1:38
2:02
1:23
0:49
2:44
0:16
8:28
0:17
7:37
0:25
7:34
0:23
0:12
4:32
0 ：50
0:30
2:05
0:50
7:39
1:10
1:30
0： 24
1:40
0:05
2:55
0:10
7:48
0:10
0:10
0:14
2:37
2:04
1:01
2:35
0:06
6:42
0:20
0:20
0:13
5:53
0:27
2:55
0:10
0:28
0:11
1:46
1:55
0:59
4:40
0:08
6:19
0:18
0:45
3:18
0:50
2:20
0:20
0:10
6:10
0:21
0:09
0:20
5:52
0:23
1 ：46
0:10
7:03
0:20
3:55
1:02
1:52
0： 28
2:54
0:17
0:11
1:45
0:10
5:52
0:50
1:20
0:10
0:20
3:36
0:55
0:25
0:25
0:14
0:41
2:58
0:10
0:10
1:03
0:35
1:10
1:33
0:30
4:10
0:18
6:03
0:26
2:57
0:53
6:58
0:32
1:57
0:25
5:09
3:16
6:08
2:20
3:59
4:17
5:15
0:31
2 ：40
5:34
0:58
2:36
6:13
0:26
2:55
5： 48
6:40
1:30
0:30
1:14
0:50
0:20
0:20
0:25
2:05
5:04
0:35
2:09
1:02
0:45
5:22
0:30
7:55
8:11
5:37
3:03
3:34
6:50
2:55
2:30
0:40
0:31
3:54
7:05
0:27
1:08
3:29
0:29
2:56
0:20
0:42
0:05
6:00
0:37
0:28
2:10
0:40
0:25
2 ：45
0:30
3:37
0:55
1:40
0:40
3:05
5： 42
0:10
1:15
8:01
6:50
7:21
6:30
7:13
7:00
6:25
1:30
4:11
0:37
1:10
9:22
6:40
9:15
0:10
0:45
0:45
0:30
1:00
1:15
1:50
0:30
2:15
0:25
0:50
1:10
3:03
1:10
0:55
0:20
2:25
1:10
0:10
0:10
0:50
2:50
0:15
2:50
1:00
0:45
1 ：00
1:15
4:15
0:20
0:20
1:20
0:00
0： 10
4:55
0:35
1:40
11:15
1:03
3:55
0:20
0:18
0:07
0:10
1:40
0:59
2:20
0:10
0:50
0:30
0:17
1:56
1:40
0:55
0:30
0:57
0:45
3:53
0:32
0:25
0:35
0:05
3:38
0:32
2:28
0:38
2:39
0:20
0:40
1:20
0:20
0:07
2:46
0:39
1:15
1:24
2 ：53
1:35
0:35
2:40
0:25
0:47
0:10
1： 35
1:08
1:12
0:16
1:18
0:26
0:25
0:44
0:11
0:10
0:07
0:15
0:14
0:17
4:40
0:39
0:25
0:50
0:20
6:15
1:37
0:17
3:45
0:38
0:30
1:20
5:45
0:40
0:50
2:15
0:48
0:27
0:08
0:12
1:45
0:25
0:17
0:07
0:06
0:35
5:53
0:15
0:47
6 ：55
1:20
0:38
1:00
0:15
3:55
1:35
0： 25
5:27
0:28
0:45
0:05
3:38
0:55
0:55
2:00
0:13
0:35
5:10
0:35
0:20
0:10
0:50
0:35
2:37
3:25
0:30
0:45
0:35
0:15
1:28
1:00
0:15
0:35
0:50
1:50
0:10
0:45
0:50
1:20
0:45
2:05
0:30
1:04
0:47
0:40
0:28
0:27
1:30
1:05
0 ：30
0:56
0:15
0:35
1:00
1:30
2:18
0： 55
1:13
0:34
0:09
3:45
0:40
1:00
0:40
0:30
2:15
1:55
3:00
2:13
0:25
0:34
0:49
2:45
1:48
0:42
2:10
0:30
0:30
0:10
3:35
0:30
1:00
1:15
3:09
3:55
4:20
4:10
1:35
1:20
0:32
0:55
1:05
2:29
0:35
0:25
1:02
1:10
1:55
0:55
0 ：45
0:12
2:03
0:20
0:30
1:37
0:43
0： 40
5:35
3:41
0:44
0:28
1:10
0:22
0:25
0:07
3:25
1:59
0:45
1:59
0:25
1:47
0:23
3:36
2:06
1:43
0:35
0:45
0:30
2:04
2:25
5:10
0:45
1:30
4:20
1:00
0:30
0:50
0:45
0:29
1:10
1:20
4:30
0:45
1:15
3:25
0:30
3:40
0:35
0:29
1 ：20
0:17
4:39
0:31
0:55
0:20
0:20
6： 50
3:00
0:30
1:47
0:15
0:35
0:10
2:45
0:40
0:10
0:30
1:58
0:25
0:18
0:50
0:23
0:16
3:04
0:15
0:55
0:42
3:17
0:20
0:15
0:51
0:41
4:35
3:35
0:45
0:20
0:15
0:45
0:55
1:05
2:50
2:15
0:30
2:10
0:25
0:10
2:35
1:02
0:40
0 ：25
2:25
0:15
19:08
0:30
1:35
2:50
3： 39
7:18
7:46
0:51
0:22
4:17
0:39
1:12
0:17
0:15
0:10
0:21
1:19
5:19
0:25
2:14
0:18
1:45
0:32
0:55
1:25
0:35
3:201:302:201:121:001:001:407:550:150:201:201:303:200:151:201:170:331:202:252:540:190:101:351:452:150:200:450:174:473:001:005:300:300:051:504:052:181:153:050:300:103:000:453:005:056:001:202:200:130:205:205:200:200:096:550:203:112:307:007:000:200:148:460:155:100:200:252:050:103:172:590:251:350:151:050:351:552:400:302:050:200:173:201:154:301:200:101:351:001:550:500:151:100:101:451:000:501:101:251:051:500:120:301:150:453:301:350:150:100:500:307:100:181:150:200:251:153:001:000:253:390:132:470:251:050:260:150:253:142:450:402:200:380:122:372:036:550:184:300:101:003:452:400:100:291:180:500:565:440:140:300:151:005:252:050:550:094:050:350:300:100:153:082:532:430:311:250:101:431:001:201:200:151:305:052:550:200:104:252:400:080:130:129:500:150:250:104:300:350:150:101:201:003:092:417:340:111:050:200:101:590:202:020:380:352:150:220:124:370:352:100:101:542:500:403:120:090:091:210:353:303:000:250:290:167:210:054:522:300:450:250:400:203:480:372:530:150:501:400:132:111:300:500:380:051:550:392:020:431:560:100:154:290:400:350:150:442:170:140:083:090:490:582:211:382:021:230:492:440:168:280:177:370:257:340:230:124:320:500:302:050:507:391:101:300:241:400:052:550:107:480:100:100:142:372:041:012:350:066:420:200:200:135:530:272:550:100:280:111:461:550:594:400:086:190:180:453:180:502:200:200:106:100:210:090:205:520:231:460:107:030:203:551:021:520:282:540:170:111:450:105:520:501:200:100:203:360:550:250:250:140:412:580:100:101:030:351:101:330:304:100:186:030:262:570:536:580:321:570:255:093:166:082:203:594:175:150:312:405:340:582:366:130:262:555:486:401:300:301:140:500:200:200:252:055:040:352:091:020:455:220:307:558:115:373:033:346:502:552:300:400:313:547:050:271:083:290:292:560:200:420:056:000:370:282:100:400:252:450:303:370:551:400:403:055:420:101:158:016:507:216:307:137:006:251:304:110:371:109:226:409:150:100:450:450:301:001:151:500:302:150:250:501:103:031:100:550:202:251:100:100:100:502:500:152:501:000:451:001:154:150:200:201:200:000:104:550:351:4011:151:033:550:200:180:070:101:400:592:200:100:500:300:171:561:400:550:300:570:453:530:320:250:350:053:380:322:280:382:390:200:401:200:200:072:460:391:151:242:531:350:352:400:250:470:101:351:081:120:161:180:260:250:440:110:100:070:150:140:174:400:390:250:500:206:151:370:173:450:380:301:205:450:400:502:150:480:270:080:121:450:250:170:070:060:355:530:150:476:551:200:381:000:153:551:350:255:270:280:450:053:380:550:552:000:130:355:100:350:200:100:500:352:373:250:300:450:350:151:281:000:150:350:501:500:100:450:501:200:452:050:301:040:470:400:280:271:301:050:300:560:150:351:001:302:180:551:130:340:093:450:401:000:400:302:151:553:002:130:250:340:492:451:480:422:100:300:300:103:350:301:001:153:093:554:204:101:351:200:320:551:052:290:350:251:021:101:550:550:450:122:030:200:301:370:430:405:353:410:440:281:100:220:250:073:251:590:451:590:251:470:233:362:061:430:350:450:302:042:255:100:451:304:201:000:300:500:450:291:101:204:300:451:153:250:303:400:350:291:200:174:390:310:550:200:206:503:000:301:470:150:350:102:450:400:100:301:580:250:180:500:230:163:040:150:550:423:170:200:150:510:414:353:350:450:200:150:450:551:052:502:150:302:100:250:102:351:020:400:252:250:1519:080:301:352:503:397:187:460:510:224:170:391:120:170:150:100:211:195:190:252:140:181:450:320:551:250:35
我正在获得的正常SUM是： 00:36
And the normal SUM I'm getting is: 00:36
什么是我没有？
任何帮助赞赏。
推荐答案
normal = SUM（A2：A3），并将结果单元格的单元格格式掩码设置为d hh：mm或[h]：mm
Sum them as normal =SUM(A2:A3) and set the cell format mask for the result cell as d hh:mm or [h]:mm
这篇关于如何添加两列有时间的列值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！