Spreadsheet: 692709d1598517917-split-one-colunm-in-severals-columns-in-accordance-with-criterias-4
Sheet: Sheet 1

考勤号码 | 姓名 | 部门 | 日期 | 时间 | eDate
12 | 莫佳意 | [NAME] | 2020/8/26 | 07:57 | 2020-08-26 00:00:00
14 | 李浅 | [NAME] | 2020/8/26 | 07:55 12:03 17:32 | 2020-08-26 00:00:00
31 | 罗良栋 | [NAME] | 2020/8/26 | 07:57 17:36 | 2020-08-26 00:00:00
69 | 李润连 | [NAME] | 2020/8/26 | 07:50 12:01 | 2020-08-26 00:00:00
70 | 黎金莲 | [NAME] | 2020/8/26 | 07:46 12:00 22:00 | 2020-08-26 00:00:00
82 | 肖国琼 | [NAME] | 2020/8/26 | 07:59 12:01 17:32 | 2020-08-26 00:00:00
98 | 周志平 | [NAME] | 2020/8/26 | 07:57 17:32 | 2020-08-26 00:00:00
126 | [NAME] | [NAME] | 2020/8/26 | 07:55 12:00 | 2020-08-26 00:00:00
242 | 余水兰 | [NAME] | 2020/8/26 | 07:46 12:02 | 2020-08-26 00:00:00
425 | 杨秋华 | [NAME] | 2020/8/26 | 17:32 | 2020-08-26 00:00:00
541 | 杨通芝 | [NAME] | 2020/8/26 | 07:51 17:31 | 2020-08-26 00:00:00
644 | 何英 | [NAME] | 2020/8/26 | 07:56 12:02 22:01 | 2020-08-26 00:00:00
723 | 唐明杰 | [NAME] | 2020/8/26 | 07:45 12:00 | 2020-08-26 00:00:00
729 | 王德荣 | [NAME] | 2020/8/26 | 07:52 12:05 22:00 | 2020-08-26 00:00:00
779 | 黄宁芳 | [NAME] | 2020/8/26 | 07:55 17:30 | 2020-08-26 00:00:00
790 | 周武明 | [NAME] | 2020/8/26 | 07:55 17:30 | 2020-08-26 00:00:00
792 | 黄华 | [NAME] | 2020/8/26 | 07:59 | 2020-08-26 00:00:00
861 | 朱方英 | [NAME] | 2020/8/26 | 07:51 12:02 | 2020-08-26 00:00:00
862 | 周婷婷 | [NAME] | 2020/8/26 | 07:54 17:32 | 2020-08-26 00:00:00
891 | 何世坤 | [NAME] | 2020/8/26 | 07:53 17:30 | 2020-08-26 00:00:00
920 | 罗其会 | [NAME] | 2020/8/26 | 07:50 17:32 | 2020-08-26 00:00:00
967 | [NAME] | [NAME] | 2020/8/26 | 07:46 12:00 | 2020-08-26 00:00:00
968 | 杨登梅 | [NAME] | 2020/8/26 | 07:53 12:00 22:01 | 2020-08-26 00:00:00
973 | 陆学旺 | [NAME] | 2020/8/26 | 07:49 12:02 | 2020-08-26 00:00:00
974 | 王盼 | [NAME] | 2020/8/26 | 07:49 12:01 | 2020-08-26 00:00:00
975 | 李真姬 | [NAME] | 2020/8/26 | 07:56 12:00 | 2020-08-26 00:00:00
978 | 罗杰文 | [NAME] | 2020/8/26 | 07:53 17:31 | 2020-08-26 00:00:00
983 | 唐洪梅 | [NAME] | 2020/8/26 | 07:46 17:31 | 2020-08-26 00:00:00
987 | 蔡军炎 | [NAME] | 2020/8/26 | 07:46 17:30 | 2020-08-26 00:00:00
1001 | 曾志文 | [NAME] | 2020/8/26 | 07:46 17:31 | 2020-08-26 00:00:00
1003 | 张敏龙 | [NAME] | 2020/8/26 | 07:52 17:31 | 2020-08-26 00:00:00
1009 | 薛眉眉 | [NAME] | 2020/8/26 | 07:45 12:00 | 2020-08-26 00:00:00
1015 | [NAME] | [NAME] | 2020/8/26 |  | 2020-08-26 00:00:00
1016 | 黄寿丰 | [NAME] | 2020/8/26 | 07:57 12:00 22:00 | 2020-08-26 00:00:00
1019 | 李太仙 | [NAME] | 2020/8/26 | 07:53 12:00 22:00 | 2020-08-26 00:00:00
1021 | 罗耀 | [NAME] | 2020/8/26 | 07:57 12:02 22:00 | 2020-08-26 00:00:00
1025 | 卢霞 | [NAME] | 2020/8/26 | 07:52 17:32 | 2020-08-26 00:00:00
1028 | [NAME] | [NAME] | 2020/8/26 | 07:56 17:31 | 2020-08-26 00:00:00
1029 | 袁素芳 | [NAME] | 2020/8/26 | 07:54 17:30 | 2020-08-26 00:00:00
1030 | 李剑奇 | [NAME] | 2020/8/26 | 07:56 17:30 | 2020-08-26 00:00:00
1031 | 聂宇悠 | [NAME] | 2020/8/26 | 07:57 17:30 | 2020-08-26 00:00:00
1032 | 肖丹凤 | [NAME] | 2020/8/26 | 07:54 17:30 | 2020-08-26 00:00:00
1034 | 刘洋洋 | [NAME] | 2020/8/26 | 07:53 17:31 | 2020-08-26 00:00:00
1038 | 李日连 | [NAME] | 2020/8/26 | 07:48 12:01 | 2020-08-26 00:00:00
1040 | 农凤连 | [NAME] | 2020/8/26 | 07:47 17:30 | 2020-08-26 00:00:00
1042 | 沈庆鑫 | [NAME] | 2020/8/26 | 07:52 12:01 22:00 | 2020-08-26 00:00:00
1048 | 张喜燕 | [NAME] | 2020/8/26 | 07:48 12:01 | 2020-08-26 00:00:00
1049 | 潘炳兵 | [NAME] | 2020/8/26 | 07:53 12:00 22:00 | 2020-08-26 00:00:00
1050 | 张璐 | [NAME] | 2020/8/26 | 07:49 12:01 22:01 | 2020-08-26 00:00:00
1054 | 雷必芬 | [NAME] | 2020/8/26 | 07:55 12:00 | 2020-08-26 00:00:00
1056 | 杨淑珍 | [NAME] | 2020/8/26 | 07:53 12:01 | 2020-08-26 00:00:00
1057 | 庹秀碧 | [NAME] | 2020/8/26 | 07:54 12:03 22:00 | 2020-08-26 00:00:00
1058 | 李杰 | [NAME] | 2020/8/26 | 07:53 12:00 22:00 | 2020-08-26 00:00:00
1067 | 林会平 | [NAME] | 2020/8/26 | 07:54 12:01 | 2020-08-26 00:00:00
1071 | 刘娇 | [NAME] | 2020/8/26 | 07:48 12:00 22:00 | 2020-08-26 00:00:00
1072 | 胡玉兰 | [NAME] | 2020/8/26 | 07:54 12:02 22:01 | 2020-08-26 00:00:00
1074 | 邓美娟 | [NAME] | 2020/8/26 | 07:54 12:00 22:01 | 2020-08-26 00:00:00
1075 | 涂世琼 | [NAME] | 2020/8/26 | 07:49 12:00 22:00 | 2020-08-26 00:00:00
1076 | 莫梅清 | [NAME] | 2020/8/26 | 07:51 12:02 | 2020-08-26 00:00:00
1077 | 徐珍梅 | [NAME] | 2020/8/26 | 07:52 12:01 | 2020-08-26 00:00:00
1078 | 鲁子鹅 | [NAME] | 2020/8/26 | 07:54 12:01 22:01 | 2020-08-26 00:00:00
1079 | 马朝军 | [NAME] | 2020/8/26 | 07:54 12:01 | 2020-08-26 00:00:00
1080 | 谭晶 | [NAME] | 2020/8/26 | 07:59 12:00 22:00 | 2020-08-26 00:00:00
1086 | 马素君 | [NAME] | 2020/8/26 | 07:49 12:00 22:00 | 2020-08-26 00:00:00
1087 | 卢西玲 | [NAME] | 2020/8/26 | 07:50 12:01 | 2020-08-26 00:00:00
1090 | 谭可弟 | [NAME] | 2020/8/26 | 07:52 12:00 22:00 | 2020-08-26 00:00:00
1092 | 杨欣 | [NAME] | 2020/8/26 |  | 2020-08-26 00:00:00
1094 | 秦冬雪 | [NAME] | 2020/8/26 | 07:57 12:01 | 2020-08-26 00:00:00
1098 | 邱雪儿 | [NAME] | 2020/8/26 | 07:49 12:01 | 2020-08-26 00:00:00
1099 | [NAME] | [NAME] | 2020/8/26 | 07:57 12:01 | 2020-08-26 00:00:00
1100 | 王敬友 | [NAME] | 2020/8/26 | 07:56 12:00 | 2020-08-26 00:00:00
1101 | 王坤运 | [NAME] | 2020/8/26 | 07:55 12:01 22:00 | 2020-08-26 00:00:00
1103 | 温小华 | [NAME] | 2020/8/26 | 12:01 22:00 | 2020-08-26 00:00:00
1105 | 王改 | [NAME] | 2020/8/26 | 07:47 12:00 22:00 | 2020-08-26 00:00:00
1108 | 王高辉 | [NAME] | 2020/8/26 | 07:58 17:30 | 2020-08-26 00:00:00
1109 | 韦月梅 | [NAME] | 2020/8/26 | 07:54 17:30 | 2020-08-26 00:00:00
1111 | 劳远凤 | [NAME] | 2020/8/26 | 07:58 17:30 | 2020-08-26 00:00:00
1112 | 劳秀明 | [NAME] | 2020/8/26 | 07:58 17:30 | 2020-08-26 00:00:00
1117 | [NAME] | [NAME] | 2020/8/26 | 07:53 17:32 | 2020-08-26 00:00:00
1119 | 刘莉 | [NAME] | 2020/8/26 | 07:48 17:31 | 2020-08-26 00:00:00
1120 | 李珍 | [NAME] | 2020/8/26 | 07:53 17:31 | 2020-08-26 00:00:00
1121 | 朱玲 | [NAME] | 2020/8/26 | 07:46 17:31 | 2020-08-26 00:00:00
1126 | 陈天杰 | [NAME] | 2020/8/26 | 07:00 | 2020-08-26 00:00:00
1130 | 许志连 | [NAME] | 2020/8/26 | 07:47 17:31 | 2020-08-26 00:00:00
1131 | 丁嘉乐 | [NAME] | 2020/8/26 | 07:50 17:31 | 2020-08-26 00:00:00
1132 | 姚仁波 | [NAME] | 2020/8/26 | 07:48 17:31 | 2020-08-26 00:00:00
1135 | 李光雄 | [NAME] | 2020/8/26 | 07:52 17:30 | 2020-08-26 00:00:00
1136 | [NAME] | [NAME] | 2020/8/26 | 07:50 17:30 | 2020-08-26 00:00:00
1139 | 邓翼清 | [NAME] | 2020/8/26 |  | 2020-08-26 00:00:00
1140 | 杨贵新 | [NAME] | 2020/8/26 | 07:50 17:32 | 2020-08-26 00:00:00
2022 | 罗彩花 | [NAME] | 2020/8/26 |  | 2020-08-26 00:00:00