Spreadsheet: 692718d1598522573-split-one-colunm-in-severals-columns-in-accordance-with-criterias-4-manual-simulation
Sheet: Sheet 1

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