请问怎么将中国移动的话费清单的通话时间汇总?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:38:1100:07:0100:00:2900:24:5000:01:1800:11:5100:36:3200:02:1500:12:2100:01:1100:10:4800:10:3800:00:5700:19:1100:29:2000:00:2100:21:1000:09:2200:00:10
网友回答
【答案】 因为一般情况下,从系统中保存的数据为文本格式的,需要转化成时间格式的.
假设你的数据在A1：A42,在B1中输入下列公式：
=TIME(LEFT(A1,2),MID(A1,4,2),RIGHT(A1,2))
然后右击B1单元格,设置单元格式格式为时间.
然后将鼠标移到B1右下角成“+”时,按左键,下拉到B42,再选中B43,输入：sum(B1:B42)
即可.