1、首先,将每个人的姓名和相应的打卡时间记录在Excel之中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cef6fa5e47bb003af33a87b26c?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/ca1349540923dd545d981826dc09b3de9d824890?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/80cb39dbb6fd5266c670b05aa618972bd4073620?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/4d086e061d950a7b5991c28a07d162d9f3d3c9dc?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/1b4c510fd9f9d72ad8f7af53d92a2834359bbbe9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、根据上面的步骤,在“加班时间”这一列的对应方,如图所示,输入函数“=TEXT(MOD(C2-B2,1),"h小时m分钟")”,然后点击回车键,显示D2内容。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b17eca8065380cd7328c2ea3ac44ad34588281ea?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、在显示结果栏的下方出现十字形光标时,下拉或者双击,则可以填充所有的内容了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf89fc7e871d4f9d72a6159a7ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)