早教吧 育儿知识 作业答案 考试题库 百科 知识分享

请问怎么将中国移动的话费清单的通话时间汇总?00:09:3000:18:3800:24:0400:18:4900:01:0600:00:1200:22:3100:00:1000:06:5300:00:5800:00:3600:01:4000:02:1400:01:3401:22:5100:20:2700:01:2000:43:0700:20:0100:00:1600:49:1100:01:3601:26:5200

题目详情
请问怎么将中国移动的话费清单的通话时间汇总?
00:09:30
00:18:38
00:24:04
00:18:49
00:01:06
00:00:12
00:22:31
00:00:10
00:06:53
00:00:58
00:00:36
00:01:40
00:02:14
00:01:34
01:22:51
00:20:27
00:01:20
00:43:07
00:20:01
00:00:16
00:49:11
00:01:36
01:26:52
00:38:11
00:07:01
00:00:29
00:24:50
00:01:18
00:11:51
00:36:32
00:02:15
00:12:21
00:01:11
00:10:48
00:10:38
00:00:57
00:19:11
00:29:20
00:00:21
00:21:10
00:09:22
00:00:10
▼优质解答
答案和解析
因为一般情况下,从系统中保存的数据为文本格式的,需要转化成时间格式的.假设你的数据在A1:A42,在B1中输入下列公式:=TIME(LEFT(A1,2),MID(A1,4,2),RIGHT(A1,2))然后右击B1单元格,设置单元格式格式为时间.然后将鼠标...