1、不少考勤系统记录下来的每天考勤情况形如下图所示,可以看到,当天所有的出勤记录都在一个单元格内,无法进行有效统计。因此,需要对这些考勤记录进行分列,去掉非加班记录,才能进行加班工时统计。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9773d708e3701213fb80e9151?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中所有打卡记录,如下图所示,依次打开“数据”-“分列”菜单。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dc9226cbc6c311728b47102849?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着,在文本分列向导里选择合适的文件类型。一般各个记录之间是空格等分隔符号隔开,因此,需要选“分隔符号”。然后单击“下一步”进行下一步骤的操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1c950a7b02087bf4ae8c13befcd3572c11dfcf01?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、接着,根据记录数据的情况选择分隔符号,例如本文演示的数据里用的是空格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b03533fa828ba61e9a9e8c784f34970a304e5970?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、接着再选择分列后每列的数据格式,一般选“常规”即可。至此,分列设置完成,单击“完成”按钮即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8b13632762d0f7033ff9d18b06fa513d2697c51a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)