สูตรเกี่ยวกับเวลา ช่วงเวลาให้แสดงผลของช่วงเวลา เป็นสถานะ กะ
Posted: Tue Mar 01, 2022 3:39 pm
ขอสอบถามอาจารย์ดังนี้
อยากได้สูตรคำนวณช่วงเวลา เข้างานของพนักงาน โดยจะมีไฟล์เวลาเข้างานและวันที่ อยากได้สูตรที่สามารถแสดงว่าพนักงานเข้ากะ อะไรบ้าง พอจะมีไหมคะ
รหัสนิ้วมือ รหัสพนักงาน ชื่อ-สกุล วันที่ เวลา กะทำงาน สถานะ สถานะใหม่ เหตุผล
699 SDS0699 Worapol 16-02-22 10:48 PM C/In Invalid
699 SDS0699 Worapol 17-02-22 7:35 AM C/In Invalid
726 SDS0726 Mana G 16-02-22 7:39 AM C/In OverTime In FOT
726 SDS0726 Mana G 16-02-22 5:06 PM C/Out OverTime Out FOT
726 SDS0726 Mana G 17-02-22 7:33 AM C/In Invalid
737 SDS0737 Somporn 16-02-22 7:33 AM C/In Invalid
737 SDS0737 Somporn 16-02-22 10:48 PM C/In Invalid
737 SDS0737 Somporn 17-02-22 7:36 AM C/In Invalid
741 SDS0741 Naret 16-02-22 7:34 AM C/In Invalid
741 SDS0741 Naret 16-02-22 10:27 PM C/Out Invalid
741 SDS0741 Naret 17-02-22 7:37 AM C/In Invalid
744 SDS0744 744 16-02-22 2:42 PM C/In OverTime In FOT
744 SDS0744 744 16-02-22 11:33 PM C/In OverTime Out FOT
762 SDS0762 762 16-02-22 2:58 PM C/In OverTime In FOT
762 SDS0762 762 16-02-22 11:34 PM OverTime Out FOT
774 SDS0774 Pornphan 16-02-22 6:58 AM C/In OverTime In FOT
774 SDS0774 Pornphan 16-02-22 3:41 PM C/Out OverTime Out FOT
774 SDS0774 Pornphan 17-02-22 6:54 AM C/In Invalid
776 SDS0776 Sanon 16-02-22 6:37 AM C/In OverTime In FOT
776 SDS0776 Sanon 16-02-22 3:34 PM C/In OverTime Out FOT
776 SDS0776 Sanon 17-02-22 6:35 AM C/In Invalid
778 SDS0778 Tharadon 16-02-22 7:46 AM C/In OverTime In FOT
778 SDS0778 Tharadon 16-02-22 5:03 PM C/Out OverTime Out FOT
778 SDS0778 Tharadon 17-02-22 7:52 AM C/In Invalid
788 SDS0788 Wanchana 16-02-22 7:42 PM C/Out OverTime In FOT
788 SDS0788 Wanchana 17-02-22 5:03 AM OverTime Out FOT
798 SDS0798 Banyat 16-02-22 7:53 PM C/Out OverTime In FOT
798 SDS0798 Banyat 17-02-22 5:04 AM OverTime Out FOT
799 SDS0799 Jirasak 16-02-22 7:33 AM C/In Invalid
799 SDS0799 Jirasak 16-02-22 10:42 PM C/In Invalid
799 SDS0799 Jirasak 17-02-22 7:36 AM C/In Invalid
811 SDS0811 Saksada 16-02-22 6:36 AM C/In OverTime In FOT
811 SDS0811 Saksada 16-02-22 3:37 PM C/Out OverTime Out FOT
811 SDS0811 Saksada 17-02-22 6:34 AM C/In Invalid
812 SDS0812 Charatwi 16-02-22 10:29 PM C/Out Invalid
812 SDS0812 Charatwi 17-02-22 7:35 AM C/In Invalid
813 SDS0813 Ausa A 16-02-22 6:29 AM C/Out OverTime In FOT
813 SDS0813 Ausa A 16-02-22 3:31 PM C/In OverTime Out FOT
813 SDS0813 Ausa A 17-02-22 6:51 AM C/In Invalid
817 SDS0817 Nuttawut 16-02-22 2:51 PM C/In OverTime In FOT
817 SDS0817 Nuttawut 16-02-22 11:38 PM OverTime Out FOT
824 SDS0824 Supatar 16-02-22 2:49 PM C/In OverTime In FOT
824 SDS0824 Supatar 16-02-22 11:34 PM OverTime Out FOT
827 SDS0827 Phumphua 16-02-22 6:51 AM C/In OverTime In FOT
827 SDS0827 Phumphua 16-02-22 3:37 PM C/Out OverTime Out FOT
827 SDS0827 Phumphua 17-02-22 6:54 AM C/In Invalid
839 SDS0839 Kittitya 16-02-22 2:47 PM C/In OverTime In FOT
839 SDS0839 Kittitya 16-02-22 11:39 PM OverTime Out FOT
846 SDS0846 Piyanun 16-02-22 2:39 PM C/In OverTime In FOT
846 SDS0846 Piyanun 16-02-22 11:36 PM OverTime Out FOT
848 SDS0848 Thaweeki 16-02-22 6:45 AM C/In OverTime In FOT
848 SDS0848 Thaweeki 16-02-22 3:41 PM C/Out OverTime Out FOT
848 SDS0848 Thaweeki 17-02-22 6:49 AM C/In Invalid
849 SDS0849 Phusanis 16-02-22 7:36 AM C/In Invalid
849 SDS0849 Phusanis 16-02-22 10:48 PM C/In Invalid
849 SDS0849 Phusanis 17-02-22 7:41 AM C/In Invalid
853 SDS0853 Jantima 16-02-22 7:37 AM C/In Invalid
855 SDS0855 Siriwat 16-02-22 6:52 AM C/In OverTime In FOT
855 SDS0855 Siriwat 16-02-22 3:31 PM C/In OverTime Out FOT
855 SDS0855 Siriwat 17-02-22 6:56 AM C/In Invalid
874 SDS0874 Kittikor 16-02-22 6:41 AM C/In OverTime In FOT
874 SDS0874 Kittikor 16-02-22 3:33 PM C/In OverTime Out FOT
874 SDS0874 Kittikor 17-02-22 6:48 AM C/In Invalid
880 SDS0880 Watchari 16-02-22 10:42 PM C/In Invalid
880 SDS0880 Watchari 17-02-22 7:36 AM C/In Invalid
881 SDS0881 Aomsup 16-02-22 6:52 AM C/In OverTime In FOT
881 SDS0881 Aomsup 16-02-22 3:32 PM C/In OverTime Out FOT
881 SDS0881 Aomsup 17-02-22 6:58 AM C/In Invalid
892 SDS0892 Porameat 16-02-22 7:30 AM C/In Invalid
892 SDS0892 Porameat 16-02-22 10:44 PM C/In Invalid
892 SDS0892 Porameat 17-02-22 7:31 AM C/In Invalid
895 SDS0895 Pornpana 16-02-22 7:30 AM C/In Invalid
895 SDS0895 Pornpana 16-02-22 10:55 PM C/In Invalid
895 SDS0895 Pornpana 17-02-22 7:32 AM C/In Invalid
896 SDS0896 Rattanap 16-02-22 7:32 AM C/In Invalid
896 SDS0896 Rattanap 16-02-22 10:36 PM C/Out Invalid
896 SDS0896 Rattanap 17-02-22 7:41 AM C/In Invalid
898 SDS0898 Nut No 17-02-22 7:51 AM C/In Invalid
900 SDS0900 Maneerat 16-02-22 7:43 AM C/In OverTime In FOT
900 SDS0900 Maneerat 16-02-22 5:04 PM C/Out OverTime Out FOT
900 SDS0900 Maneerat 17-02-22 7:50 AM C/In Invalid
903 SDS0903 Thinako 16-02-22 7:38 AM C/In Invalid
903 SDS0903 Thinako 16-02-22 10:36 PM C/Out Invalid
903 SDS0903 Thinako 17-02-22 7:32 AM C/In Invalid
906 SDS0906 Jennaron 16-02-22 10:55 PM C/In Invalid
906 SDS0906 Jennaron 17-02-22 7:31 AM C/In Invalid
908 SDS0908 Natwara 16-02-22 6:44 AM C/In OverTime In FOT
908 SDS0908 Natwara 16-02-22 3:33 PM C/In OverTime Out FOT
908 SDS0908 Natwara 17-02-22 6:49 AM C/In Invalid
912 SDS0912 Thidapor 16-02-22 2:33 PM C/In OverTime In FOT
912 SDS0912 Thidapor 16-02-22 11:34 PM OverTime Out FOT
917 SDS0917 Yuphawan 16-02-22 2:29 PM C/In OverTime In FOT
917 SDS0917 Yuphawan 16-02-22 11:38 PM OverTime Out FOT
918 SDS0918 Wathanyu 16-02-22 6:41 AM C/In OverTime In FOT
918 SDS0918 Wathanyu 16-02-22 3:34 PM C/In OverTime Out FOT
918 SDS0918 Wathanyu 17-02-22 6:40 AM C/In Invalid
920 SDS0920 Pornthip 16-02-22 6:27 AM C/Out OverTime In FOT
920 SDS0920 Pornthip 16-02-22 3:41 PM C/Out OverTime Out FOT
920 SDS0920 Pornthip 17-02-22 6:39 AM C/In Invalid
926 SDS0926 Tanundor 16-02-22 6:45 AM C/In OverTime In FOT
926 SDS0926 Tanundor 16-02-22 3:31 PM C/In OverTime Out FOT
926 SDS0926 Tanundor 17-02-22 6:45 AM C/In Invalid
934 SDS0934 Somkiat 16-02-22 7:47 AM C/In OverTime In FOT
934 SDS0934 Somkiat 16-02-22 5:03 PM C/Out OverTime Out FOT
934 SDS0934 Somkiat 17-02-22 7:41 AM C/In Invalid
936 SDS0936 Phenporn 16-02-22 6:40 AM C/In OverTime In FOT
936 SDS0936 Phenporn 16-02-22 3:32 PM C/In OverTime Out FOT
936 SDS0936 Phenporn 17-02-22 6:46 AM C/In Invalid
937 SDS0937 Amnuai 16-02-22 6:54 AM C/In OverTime In FOT
937 SDS0937 Amnuai 16-02-22 3:32 PM C/In OverTime Out FOT
937 SDS0937 Amnuai 17-02-22 6:55 AM C/In Invalid
943 SDS0943 Sitthira 16-02-22 7:31 AM C/In Invalid
943 SDS0943 Sitthira 16-02-22 10:41 PM C/In Invalid
943 SDS0943 Sitthira 17-02-22 7:33 AM C/In Invalid
952 SDS0952 Preedee 16-02-22 2:24 PM C/In OverTime In FOT
952 SDS0952 Preedee 16-02-22 11:33 PM OverTime Out FOT
954 SDS0954 Suphansa 16-02-22 7:30 AM C/In Invalid
954 SDS0954 Suphansa 16-02-22 10:51 PM C/In Invalid
954 SDS0954 Suphansa 17-02-22 7:32 AM C/In Invalid
959 SDS0959 wanchai 16-02-22 6:49 AM C/In OverTime In FOT
959 SDS0959 wanchai 16-02-22 3:34 PM C/In OverTime Out FOT
959 SDS0959 wanchai 17-02-22 6:52 AM C/In Invalid
965 SDS0965 Saran 16-02-22 6:42 AM C/In OverTime In FOT
965 SDS0965 Saran 16-02-22 3:33 PM C/In OverTime Out FOT
965 SDS0965 Saran 17-02-22 6:54 AM C/In Invalid
971 SDS0971 Sorada 16-02-22 7:30 AM C/In Invalid
971 SDS0971 Sorada 16-02-22 10:37 PM C/In Invalid
971 SDS0971 Sorada 17-02-22 7:32 AM C/In Invalid
972 SDS0972 Phaisan 16-02-22 4:03 PM C/Out Invalid
972 SDS0972 Phaisan 17-02-22 6:01 AM OverTime Out Invalid
986 SDS0986 Konsak 16-02-22 2:02 AM C/Out OverTime Out FOT
986 SDS0986 Konsak 16-02-22 4:32 PM C/Out OverTime In FOT
986 SDS0986 Konsak 17-02-22 2:10 AM OverTime Out FOT
992 SDS0992 Chonlath 16-02-22 2:30 PM C/In OverTime In FOT
992 SDS0992 Chonlath 16-02-22 11:34 PM OverTime Out FOT
993 SDS0993 Natthaph 16-02-22 2:50 PM C/In OverTime In FOT
993 SDS0993 Natthaph 16-02-22 11:37 PM OverTime Out FOT
996 SDS0996 Weerayut 16-02-22 6:51 AM C/In OverTime In FOT
996 SDS0996 Weerayut 16-02-22 3:30 PM C/In OverTime Out FOT
996 SDS0996 Weerayut 17-02-22 6:56 AM C/In Invalid
1004 SDS1004 Phongphi 16-02-22 7:31 AM C/In Invalid
1004 SDS1004 Phongphi 16-02-22 10:47 PM C/In Invalid
1004 SDS1004 Phongphi 17-02-22 7:33 AM C/In Invalid
1005 SDS1005 Nareerat 16-02-22 2:52 PM C/In OverTime In FOT
1005 SDS1005 Nareerat 16-02-22 11:33 PM C/In OverTime Out FOT
1015 SDS1015 Partchar 16-02-22 2:12 PM C/In OverTime In FOT
1015 SDS1015 Partchar 16-02-22 11:34 PM OverTime Out FOT
1019 SDS1019 Ronnayut 16-02-22 7:00 AM C/In OverTime In FOT
1019 SDS1019 Ronnayut 16-02-22 3:31 PM C/In OverTime Out FOT
1019 SDS1019 Ronnayut 17-02-22 6:58 AM C/In Invalid
1023 SDS1023 Pakin 17-02-22 7:40 AM C/In Invalid
1026 SDS1026 Chaloemc 16-02-22 2:50 PM C/In OverTime In FOT
1026 SDS1026 Chaloemc 16-02-22 11:37 PM OverTime Out FOT
1028 SDS1028 Suphache 16-02-22 6:49 AM C/In OverTime In FOT
1028 SDS1028 Suphache 16-02-22 3:38 PM C/Out OverTime Out FOT
1028 SDS1028 Suphache 17-02-22 6:54 AM C/In Invalid
1040 SDS1040 Kantana 16-02-22 2:20 PM C/In OverTime In FOT
1040 SDS1040 Kantana 16-02-22 11:38 PM OverTime Out FOT
1043 SDS1043 Teerapat 16-02-22 6:32 AM C/Out OverTime In FOT
1043 SDS1043 Teerapat 16-02-22 3:33 PM C/In OverTime Out FOT
1043 SDS1043 Teerapat 17-02-22 6:36 AM C/In Invalid
1061 SDS1061 Aekarat 16-02-22 7:31 AM C/In Invalid
1061 SDS1061 Aekarat 16-02-22 10:25 PM C/Out Invalid
1061 SDS1061 Aekarat 17-02-22 8:01 AM C/In Invalid
1069 SDS1069 Nanathan 17-02-22 6:43 AM C/In Invalid
1071 SDS1071 Woraphon 16-02-22 7:37 AM C/In Invalid
1071 SDS1071 Woraphon 16-02-22 10:35 PM C/Out Invalid
1071 SDS1071 Woraphon 17-02-22 7:36 AM C/In Invalid
1085 SDS1085 Kamonwan 16-02-22 2:53 PM C/In OverTime In FOT
1085 SDS1085 Kamonwan 16-02-22 11:34 PM OverTime Out FOT
1099 SDS1099 Nanthida 16-02-22 7:52 AM C/In OverTime In FOT
1099 SDS1099 Nanthida 16-02-22 5:10 PM C/Out OverTime Out FOT
1099 SDS1099 Nanthida 17-02-22 7:49 AM C/In Invalid
1105 SDS1105 Namtan 16-02-22 7:32 AM C/In Invalid
1105 SDS1105 Namtan 16-02-22 10:38 PM C/In Invalid
1105 SDS1105 Namtan 17-02-22 7:38 AM C/In Invalid
1107 SDS1107 Sitipong 16-02-22 2:01 AM C/Out OverTime Out FOT
1107 SDS1107 Sitipong 16-02-22 4:38 PM C/Out OverTime In FOT
1107 SDS1107 Sitipong 17-02-22 2:02 AM OverTime Out FOT
1108 SDS1108 Amon P 16-02-22 7:42 AM C/In OverTime In FOT
1108 SDS1108 Amon P 16-02-22 5:03 PM C/Out OverTime Out FOT
1108 SDS1108 Amon P 17-02-22 7:45 AM C/In Invalid
1109 SDS1109 Sahatsaw 16-02-22 2:50 PM C/In OverTime In FOT
1109 SDS1109 Sahatsaw 16-02-22 11:49 PM OverTime Out FOT
1112 SDS1112 Rattipol 16-02-22 2:15 PM C/In OverTime In FOT
1112 SDS1112 Rattipol 16-02-22 11:34 PM OverTime Out FOT
1122 SDS1122 Boonsine 16-02-22 7:37 AM C/In Invalid
1124 SDS1124 Sunan 16-02-22 6:40 AM C/In OverTime In FOT
1124 SDS1124 Sunan 16-02-22 3:36 PM C/In OverTime Out FOT
1124 SDS1124 Sunan 17-02-22 6:38 AM C/In Invalid
1134 SDS1134 นายสมศักดิ์ เสื 16-02-22 7:32 AM C/In Invalid
1134 SDS1134 นายสมศักดิ์ เสื 16-02-22 10:39 PM C/In Invalid
1134 SDS1134 นายสมศักดิ์ เสื 17-02-22 7:33 AM C/In Invalid
1135 SDS1135 Sitipong 16-02-22 7:31 AM C/In Invalid
1135 SDS1135 Sitipong 16-02-22 10:39 PM C/In Invalid
1135 SDS1135 Sitipong 17-02-22 7:32 AM C/In Invalid
1137 SDS1137 Mongkhol 16-02-22 6:41 AM C/In OverTime In FOT
1137 SDS1137 Mongkhol 16-02-22 3:34 PM C/In OverTime Out FOT
1137 SDS1137 Mongkhol 17-02-22 6:40 AM C/In Invalid
1139 SDS1139 Saharat 17-02-22 6:37 AM C/In Invalid
1141 SDS1141 Wichien 16-02-22 6:45 AM C/In OverTime In FOT
1141 SDS1141 Wichien 16-02-22 3:33 PM C/In OverTime Out FOT
1141 SDS1141 Wichien 17-02-22 6:48 AM C/In Invalid
1143 SDS1143 Lalita 16-02-22 6:45 AM C/In OverTime In FOT
1143 SDS1143 Lalita 16-02-22 3:36 PM C/In OverTime Out FOT
1143 SDS1143 Lalita 17-02-22 6:48 AM C/In Invalid
1147 SDS1147 Niyada 16-02-22 7:43 AM C/In Invalid
1147 SDS1147 Niyada 16-02-22 8:14 AM C/In Invalid
1154 SDS1154 Nutchare 16-02-22 6:46 AM C/In OverTime In FOT
1154 SDS1154 Nutchare 16-02-22 3:34 PM C/In OverTime Out FOT
1154 SDS1154 Nutchare 17-02-22 6:51 AM C/In Invalid
1167 SDS1167 Manich 16-02-22 6:38 AM C/In OverTime In FOT
1167 SDS1167 Manich 16-02-22 4:03 PM C/Out OverTime Out FOT
1167 SDS1167 Manich 17-02-22 6:48 AM C/In Invalid
1169 SDS1169 Arthitiy 16-02-22 6:46 AM C/In OverTime In FOT
1169 SDS1169 Arthitiy 16-02-22 3:31 PM C/In OverTime Out FOT
1169 SDS1169 Arthitiy 17-02-22 6:51 AM C/In Invalid
1176 SDS1176 Wanwisa 16-02-22 2:52 PM C/In OverTime In FOT
1176 SDS1176 Wanwisa 16-02-22 11:34 PM OverTime Out FOT
1178 SDS1178 Waribtho 16-02-22 7:35 AM C/In OverTime In FOT
1178 SDS1178 Waribtho 16-02-22 5:10 PM C/Out OverTime Out FOT
1178 SDS1178 Waribtho 17-02-22 7:40 AM C/In Invalid
1181 SDS1181 Apivhate 16-02-22 7:33 PM C/Out OverTime In FOT
1181 SDS1181 Apivhate 17-02-22 5:02 AM OverTime Out FOT
1182 SDS1182 Athichat 16-02-22 6:31 AM C/Out OverTime In FOT
1182 SDS1182 Athichat 16-02-22 3:33 PM C/In OverTime Out FOT
1182 SDS1182 Athichat 17-02-22 6:37 AM C/In Invalid
1188 SDS1188 Chanit 16-02-22 2:36 PM C/In OverTime In FOT
1188 SDS1188 Chanit 16-02-22 11:31 PM C/In OverTime Out FOT
1189 SDS1189 Autchana 16-02-22 2:35 PM C/In OverTime In FOT
1189 SDS1189 Autchana 16-02-22 11:31 PM C/In OverTime Out FOT
1197 SDS1197 Unchalee 16-02-22 7:50 AM C/In OverTime In FOT
1197 SDS1197 Unchalee 16-02-22 5:09 PM C/Out OverTime Out FOT
1197 SDS1197 Unchalee 17-02-22 7:55 AM C/In Invalid
1199 SDS1199 Nicharee 16-02-22 7:34 AM C/In Invalid
1201 SDS1201 Niran 16-02-22 7:31 AM C/In Invalid
1203 SDS1203 Tarathon 16-02-22 2:30 PM C/In OverTime In FOT
1203 SDS1203 Tarathon 16-02-22 11:32 PM C/In OverTime Out FOT
1204 SDS1204 Sumrich 16-02-22 6:50 AM C/In OverTime In FOT
1204 SDS1204 Sumrich 16-02-22 3:34 PM C/In OverTime Out FOT
1204 SDS1204 Sumrich 17-02-22 6:51 AM C/In Invalid
1206 SDS1206 Thidarat 16-02-22 7:34 AM C/In Invalid
1206 SDS1206 Thidarat 16-02-22 10:47 PM C/In Invalid
1206 SDS1206 Thidarat 17-02-22 7:38 AM C/In Invalid
1207 SDS1207 Sudarat 16-02-22 6:41 AM C/In OverTime In FOT
1207 SDS1207 Sudarat 16-02-22 3:32 PM C/In OverTime Out FOT
1207 SDS1207 Sudarat 17-02-22 6:47 AM C/In Invalid
1212 SDS1212 Natchaph 16-02-22 7:50 AM C/In OverTime In FOT
1212 SDS1212 Natchaph 16-02-22 5:02 PM C/Out OverTime Out FOT
1212 SDS1212 Natchaph 16-02-22 5:03 PM C/Out Invalid
1212 SDS1212 Natchaph 17-02-22 7:56 AM C/In Invalid
1213 SDS1213 Nattapho 16-02-22 8:18 AM C/In OverTime In FOT
1213 SDS1213 Nattapho 16-02-22 5:01 PM C/Out OverTime Out FOT
1213 SDS1213 Nattapho 16-02-22 5:03 PM C/Out Invalid
1213 SDS1213 Nattapho 17-02-22 8:04 AM C/In Invalid
1216 SDS1216 Seksan 16-02-22 2:28 PM C/In OverTime In FOT
1216 SDS1216 Seksan 16-02-22 11:32 PM C/In OverTime Out FOT
1227 SDS1227 Suchat 16-02-22 7:02 AM C/In OverTime In FOT
1227 SDS1227 Suchat 16-02-22 3:32 PM C/In OverTime Out FOT
1227 SDS1227 Suchat 17-02-22 6:56 AM C/In Invalid
1234 SDS1234 Aekkapan 16-02-22 7:35 AM C/In Invalid
1234 SDS1234 Aekkapan 16-02-22 10:29 PM C/Out Invalid
1234 SDS1234 Aekkapan 17-02-22 7:41 AM C/In Invalid
กะทำงาน
ชื่อสถานะ "กะ" เวลาเข้า เวลาออก
P 17.00 PM 02.00 AM
E 15.00 PM 23.30 PM
S 20.00 PM 05.00 AM
N 23.00 PM 07.30 AM
M 07.00 AM 15.30 PM
D 08.00 AM 17.00 PM
อยากได้สูตรคำนวณช่วงเวลา เข้างานของพนักงาน โดยจะมีไฟล์เวลาเข้างานและวันที่ อยากได้สูตรที่สามารถแสดงว่าพนักงานเข้ากะ อะไรบ้าง พอจะมีไหมคะ
รหัสนิ้วมือ รหัสพนักงาน ชื่อ-สกุล วันที่ เวลา กะทำงาน สถานะ สถานะใหม่ เหตุผล
699 SDS0699 Worapol 16-02-22 10:48 PM C/In Invalid
699 SDS0699 Worapol 17-02-22 7:35 AM C/In Invalid
726 SDS0726 Mana G 16-02-22 7:39 AM C/In OverTime In FOT
726 SDS0726 Mana G 16-02-22 5:06 PM C/Out OverTime Out FOT
726 SDS0726 Mana G 17-02-22 7:33 AM C/In Invalid
737 SDS0737 Somporn 16-02-22 7:33 AM C/In Invalid
737 SDS0737 Somporn 16-02-22 10:48 PM C/In Invalid
737 SDS0737 Somporn 17-02-22 7:36 AM C/In Invalid
741 SDS0741 Naret 16-02-22 7:34 AM C/In Invalid
741 SDS0741 Naret 16-02-22 10:27 PM C/Out Invalid
741 SDS0741 Naret 17-02-22 7:37 AM C/In Invalid
744 SDS0744 744 16-02-22 2:42 PM C/In OverTime In FOT
744 SDS0744 744 16-02-22 11:33 PM C/In OverTime Out FOT
762 SDS0762 762 16-02-22 2:58 PM C/In OverTime In FOT
762 SDS0762 762 16-02-22 11:34 PM OverTime Out FOT
774 SDS0774 Pornphan 16-02-22 6:58 AM C/In OverTime In FOT
774 SDS0774 Pornphan 16-02-22 3:41 PM C/Out OverTime Out FOT
774 SDS0774 Pornphan 17-02-22 6:54 AM C/In Invalid
776 SDS0776 Sanon 16-02-22 6:37 AM C/In OverTime In FOT
776 SDS0776 Sanon 16-02-22 3:34 PM C/In OverTime Out FOT
776 SDS0776 Sanon 17-02-22 6:35 AM C/In Invalid
778 SDS0778 Tharadon 16-02-22 7:46 AM C/In OverTime In FOT
778 SDS0778 Tharadon 16-02-22 5:03 PM C/Out OverTime Out FOT
778 SDS0778 Tharadon 17-02-22 7:52 AM C/In Invalid
788 SDS0788 Wanchana 16-02-22 7:42 PM C/Out OverTime In FOT
788 SDS0788 Wanchana 17-02-22 5:03 AM OverTime Out FOT
798 SDS0798 Banyat 16-02-22 7:53 PM C/Out OverTime In FOT
798 SDS0798 Banyat 17-02-22 5:04 AM OverTime Out FOT
799 SDS0799 Jirasak 16-02-22 7:33 AM C/In Invalid
799 SDS0799 Jirasak 16-02-22 10:42 PM C/In Invalid
799 SDS0799 Jirasak 17-02-22 7:36 AM C/In Invalid
811 SDS0811 Saksada 16-02-22 6:36 AM C/In OverTime In FOT
811 SDS0811 Saksada 16-02-22 3:37 PM C/Out OverTime Out FOT
811 SDS0811 Saksada 17-02-22 6:34 AM C/In Invalid
812 SDS0812 Charatwi 16-02-22 10:29 PM C/Out Invalid
812 SDS0812 Charatwi 17-02-22 7:35 AM C/In Invalid
813 SDS0813 Ausa A 16-02-22 6:29 AM C/Out OverTime In FOT
813 SDS0813 Ausa A 16-02-22 3:31 PM C/In OverTime Out FOT
813 SDS0813 Ausa A 17-02-22 6:51 AM C/In Invalid
817 SDS0817 Nuttawut 16-02-22 2:51 PM C/In OverTime In FOT
817 SDS0817 Nuttawut 16-02-22 11:38 PM OverTime Out FOT
824 SDS0824 Supatar 16-02-22 2:49 PM C/In OverTime In FOT
824 SDS0824 Supatar 16-02-22 11:34 PM OverTime Out FOT
827 SDS0827 Phumphua 16-02-22 6:51 AM C/In OverTime In FOT
827 SDS0827 Phumphua 16-02-22 3:37 PM C/Out OverTime Out FOT
827 SDS0827 Phumphua 17-02-22 6:54 AM C/In Invalid
839 SDS0839 Kittitya 16-02-22 2:47 PM C/In OverTime In FOT
839 SDS0839 Kittitya 16-02-22 11:39 PM OverTime Out FOT
846 SDS0846 Piyanun 16-02-22 2:39 PM C/In OverTime In FOT
846 SDS0846 Piyanun 16-02-22 11:36 PM OverTime Out FOT
848 SDS0848 Thaweeki 16-02-22 6:45 AM C/In OverTime In FOT
848 SDS0848 Thaweeki 16-02-22 3:41 PM C/Out OverTime Out FOT
848 SDS0848 Thaweeki 17-02-22 6:49 AM C/In Invalid
849 SDS0849 Phusanis 16-02-22 7:36 AM C/In Invalid
849 SDS0849 Phusanis 16-02-22 10:48 PM C/In Invalid
849 SDS0849 Phusanis 17-02-22 7:41 AM C/In Invalid
853 SDS0853 Jantima 16-02-22 7:37 AM C/In Invalid
855 SDS0855 Siriwat 16-02-22 6:52 AM C/In OverTime In FOT
855 SDS0855 Siriwat 16-02-22 3:31 PM C/In OverTime Out FOT
855 SDS0855 Siriwat 17-02-22 6:56 AM C/In Invalid
874 SDS0874 Kittikor 16-02-22 6:41 AM C/In OverTime In FOT
874 SDS0874 Kittikor 16-02-22 3:33 PM C/In OverTime Out FOT
874 SDS0874 Kittikor 17-02-22 6:48 AM C/In Invalid
880 SDS0880 Watchari 16-02-22 10:42 PM C/In Invalid
880 SDS0880 Watchari 17-02-22 7:36 AM C/In Invalid
881 SDS0881 Aomsup 16-02-22 6:52 AM C/In OverTime In FOT
881 SDS0881 Aomsup 16-02-22 3:32 PM C/In OverTime Out FOT
881 SDS0881 Aomsup 17-02-22 6:58 AM C/In Invalid
892 SDS0892 Porameat 16-02-22 7:30 AM C/In Invalid
892 SDS0892 Porameat 16-02-22 10:44 PM C/In Invalid
892 SDS0892 Porameat 17-02-22 7:31 AM C/In Invalid
895 SDS0895 Pornpana 16-02-22 7:30 AM C/In Invalid
895 SDS0895 Pornpana 16-02-22 10:55 PM C/In Invalid
895 SDS0895 Pornpana 17-02-22 7:32 AM C/In Invalid
896 SDS0896 Rattanap 16-02-22 7:32 AM C/In Invalid
896 SDS0896 Rattanap 16-02-22 10:36 PM C/Out Invalid
896 SDS0896 Rattanap 17-02-22 7:41 AM C/In Invalid
898 SDS0898 Nut No 17-02-22 7:51 AM C/In Invalid
900 SDS0900 Maneerat 16-02-22 7:43 AM C/In OverTime In FOT
900 SDS0900 Maneerat 16-02-22 5:04 PM C/Out OverTime Out FOT
900 SDS0900 Maneerat 17-02-22 7:50 AM C/In Invalid
903 SDS0903 Thinako 16-02-22 7:38 AM C/In Invalid
903 SDS0903 Thinako 16-02-22 10:36 PM C/Out Invalid
903 SDS0903 Thinako 17-02-22 7:32 AM C/In Invalid
906 SDS0906 Jennaron 16-02-22 10:55 PM C/In Invalid
906 SDS0906 Jennaron 17-02-22 7:31 AM C/In Invalid
908 SDS0908 Natwara 16-02-22 6:44 AM C/In OverTime In FOT
908 SDS0908 Natwara 16-02-22 3:33 PM C/In OverTime Out FOT
908 SDS0908 Natwara 17-02-22 6:49 AM C/In Invalid
912 SDS0912 Thidapor 16-02-22 2:33 PM C/In OverTime In FOT
912 SDS0912 Thidapor 16-02-22 11:34 PM OverTime Out FOT
917 SDS0917 Yuphawan 16-02-22 2:29 PM C/In OverTime In FOT
917 SDS0917 Yuphawan 16-02-22 11:38 PM OverTime Out FOT
918 SDS0918 Wathanyu 16-02-22 6:41 AM C/In OverTime In FOT
918 SDS0918 Wathanyu 16-02-22 3:34 PM C/In OverTime Out FOT
918 SDS0918 Wathanyu 17-02-22 6:40 AM C/In Invalid
920 SDS0920 Pornthip 16-02-22 6:27 AM C/Out OverTime In FOT
920 SDS0920 Pornthip 16-02-22 3:41 PM C/Out OverTime Out FOT
920 SDS0920 Pornthip 17-02-22 6:39 AM C/In Invalid
926 SDS0926 Tanundor 16-02-22 6:45 AM C/In OverTime In FOT
926 SDS0926 Tanundor 16-02-22 3:31 PM C/In OverTime Out FOT
926 SDS0926 Tanundor 17-02-22 6:45 AM C/In Invalid
934 SDS0934 Somkiat 16-02-22 7:47 AM C/In OverTime In FOT
934 SDS0934 Somkiat 16-02-22 5:03 PM C/Out OverTime Out FOT
934 SDS0934 Somkiat 17-02-22 7:41 AM C/In Invalid
936 SDS0936 Phenporn 16-02-22 6:40 AM C/In OverTime In FOT
936 SDS0936 Phenporn 16-02-22 3:32 PM C/In OverTime Out FOT
936 SDS0936 Phenporn 17-02-22 6:46 AM C/In Invalid
937 SDS0937 Amnuai 16-02-22 6:54 AM C/In OverTime In FOT
937 SDS0937 Amnuai 16-02-22 3:32 PM C/In OverTime Out FOT
937 SDS0937 Amnuai 17-02-22 6:55 AM C/In Invalid
943 SDS0943 Sitthira 16-02-22 7:31 AM C/In Invalid
943 SDS0943 Sitthira 16-02-22 10:41 PM C/In Invalid
943 SDS0943 Sitthira 17-02-22 7:33 AM C/In Invalid
952 SDS0952 Preedee 16-02-22 2:24 PM C/In OverTime In FOT
952 SDS0952 Preedee 16-02-22 11:33 PM OverTime Out FOT
954 SDS0954 Suphansa 16-02-22 7:30 AM C/In Invalid
954 SDS0954 Suphansa 16-02-22 10:51 PM C/In Invalid
954 SDS0954 Suphansa 17-02-22 7:32 AM C/In Invalid
959 SDS0959 wanchai 16-02-22 6:49 AM C/In OverTime In FOT
959 SDS0959 wanchai 16-02-22 3:34 PM C/In OverTime Out FOT
959 SDS0959 wanchai 17-02-22 6:52 AM C/In Invalid
965 SDS0965 Saran 16-02-22 6:42 AM C/In OverTime In FOT
965 SDS0965 Saran 16-02-22 3:33 PM C/In OverTime Out FOT
965 SDS0965 Saran 17-02-22 6:54 AM C/In Invalid
971 SDS0971 Sorada 16-02-22 7:30 AM C/In Invalid
971 SDS0971 Sorada 16-02-22 10:37 PM C/In Invalid
971 SDS0971 Sorada 17-02-22 7:32 AM C/In Invalid
972 SDS0972 Phaisan 16-02-22 4:03 PM C/Out Invalid
972 SDS0972 Phaisan 17-02-22 6:01 AM OverTime Out Invalid
986 SDS0986 Konsak 16-02-22 2:02 AM C/Out OverTime Out FOT
986 SDS0986 Konsak 16-02-22 4:32 PM C/Out OverTime In FOT
986 SDS0986 Konsak 17-02-22 2:10 AM OverTime Out FOT
992 SDS0992 Chonlath 16-02-22 2:30 PM C/In OverTime In FOT
992 SDS0992 Chonlath 16-02-22 11:34 PM OverTime Out FOT
993 SDS0993 Natthaph 16-02-22 2:50 PM C/In OverTime In FOT
993 SDS0993 Natthaph 16-02-22 11:37 PM OverTime Out FOT
996 SDS0996 Weerayut 16-02-22 6:51 AM C/In OverTime In FOT
996 SDS0996 Weerayut 16-02-22 3:30 PM C/In OverTime Out FOT
996 SDS0996 Weerayut 17-02-22 6:56 AM C/In Invalid
1004 SDS1004 Phongphi 16-02-22 7:31 AM C/In Invalid
1004 SDS1004 Phongphi 16-02-22 10:47 PM C/In Invalid
1004 SDS1004 Phongphi 17-02-22 7:33 AM C/In Invalid
1005 SDS1005 Nareerat 16-02-22 2:52 PM C/In OverTime In FOT
1005 SDS1005 Nareerat 16-02-22 11:33 PM C/In OverTime Out FOT
1015 SDS1015 Partchar 16-02-22 2:12 PM C/In OverTime In FOT
1015 SDS1015 Partchar 16-02-22 11:34 PM OverTime Out FOT
1019 SDS1019 Ronnayut 16-02-22 7:00 AM C/In OverTime In FOT
1019 SDS1019 Ronnayut 16-02-22 3:31 PM C/In OverTime Out FOT
1019 SDS1019 Ronnayut 17-02-22 6:58 AM C/In Invalid
1023 SDS1023 Pakin 17-02-22 7:40 AM C/In Invalid
1026 SDS1026 Chaloemc 16-02-22 2:50 PM C/In OverTime In FOT
1026 SDS1026 Chaloemc 16-02-22 11:37 PM OverTime Out FOT
1028 SDS1028 Suphache 16-02-22 6:49 AM C/In OverTime In FOT
1028 SDS1028 Suphache 16-02-22 3:38 PM C/Out OverTime Out FOT
1028 SDS1028 Suphache 17-02-22 6:54 AM C/In Invalid
1040 SDS1040 Kantana 16-02-22 2:20 PM C/In OverTime In FOT
1040 SDS1040 Kantana 16-02-22 11:38 PM OverTime Out FOT
1043 SDS1043 Teerapat 16-02-22 6:32 AM C/Out OverTime In FOT
1043 SDS1043 Teerapat 16-02-22 3:33 PM C/In OverTime Out FOT
1043 SDS1043 Teerapat 17-02-22 6:36 AM C/In Invalid
1061 SDS1061 Aekarat 16-02-22 7:31 AM C/In Invalid
1061 SDS1061 Aekarat 16-02-22 10:25 PM C/Out Invalid
1061 SDS1061 Aekarat 17-02-22 8:01 AM C/In Invalid
1069 SDS1069 Nanathan 17-02-22 6:43 AM C/In Invalid
1071 SDS1071 Woraphon 16-02-22 7:37 AM C/In Invalid
1071 SDS1071 Woraphon 16-02-22 10:35 PM C/Out Invalid
1071 SDS1071 Woraphon 17-02-22 7:36 AM C/In Invalid
1085 SDS1085 Kamonwan 16-02-22 2:53 PM C/In OverTime In FOT
1085 SDS1085 Kamonwan 16-02-22 11:34 PM OverTime Out FOT
1099 SDS1099 Nanthida 16-02-22 7:52 AM C/In OverTime In FOT
1099 SDS1099 Nanthida 16-02-22 5:10 PM C/Out OverTime Out FOT
1099 SDS1099 Nanthida 17-02-22 7:49 AM C/In Invalid
1105 SDS1105 Namtan 16-02-22 7:32 AM C/In Invalid
1105 SDS1105 Namtan 16-02-22 10:38 PM C/In Invalid
1105 SDS1105 Namtan 17-02-22 7:38 AM C/In Invalid
1107 SDS1107 Sitipong 16-02-22 2:01 AM C/Out OverTime Out FOT
1107 SDS1107 Sitipong 16-02-22 4:38 PM C/Out OverTime In FOT
1107 SDS1107 Sitipong 17-02-22 2:02 AM OverTime Out FOT
1108 SDS1108 Amon P 16-02-22 7:42 AM C/In OverTime In FOT
1108 SDS1108 Amon P 16-02-22 5:03 PM C/Out OverTime Out FOT
1108 SDS1108 Amon P 17-02-22 7:45 AM C/In Invalid
1109 SDS1109 Sahatsaw 16-02-22 2:50 PM C/In OverTime In FOT
1109 SDS1109 Sahatsaw 16-02-22 11:49 PM OverTime Out FOT
1112 SDS1112 Rattipol 16-02-22 2:15 PM C/In OverTime In FOT
1112 SDS1112 Rattipol 16-02-22 11:34 PM OverTime Out FOT
1122 SDS1122 Boonsine 16-02-22 7:37 AM C/In Invalid
1124 SDS1124 Sunan 16-02-22 6:40 AM C/In OverTime In FOT
1124 SDS1124 Sunan 16-02-22 3:36 PM C/In OverTime Out FOT
1124 SDS1124 Sunan 17-02-22 6:38 AM C/In Invalid
1134 SDS1134 นายสมศักดิ์ เสื 16-02-22 7:32 AM C/In Invalid
1134 SDS1134 นายสมศักดิ์ เสื 16-02-22 10:39 PM C/In Invalid
1134 SDS1134 นายสมศักดิ์ เสื 17-02-22 7:33 AM C/In Invalid
1135 SDS1135 Sitipong 16-02-22 7:31 AM C/In Invalid
1135 SDS1135 Sitipong 16-02-22 10:39 PM C/In Invalid
1135 SDS1135 Sitipong 17-02-22 7:32 AM C/In Invalid
1137 SDS1137 Mongkhol 16-02-22 6:41 AM C/In OverTime In FOT
1137 SDS1137 Mongkhol 16-02-22 3:34 PM C/In OverTime Out FOT
1137 SDS1137 Mongkhol 17-02-22 6:40 AM C/In Invalid
1139 SDS1139 Saharat 17-02-22 6:37 AM C/In Invalid
1141 SDS1141 Wichien 16-02-22 6:45 AM C/In OverTime In FOT
1141 SDS1141 Wichien 16-02-22 3:33 PM C/In OverTime Out FOT
1141 SDS1141 Wichien 17-02-22 6:48 AM C/In Invalid
1143 SDS1143 Lalita 16-02-22 6:45 AM C/In OverTime In FOT
1143 SDS1143 Lalita 16-02-22 3:36 PM C/In OverTime Out FOT
1143 SDS1143 Lalita 17-02-22 6:48 AM C/In Invalid
1147 SDS1147 Niyada 16-02-22 7:43 AM C/In Invalid
1147 SDS1147 Niyada 16-02-22 8:14 AM C/In Invalid
1154 SDS1154 Nutchare 16-02-22 6:46 AM C/In OverTime In FOT
1154 SDS1154 Nutchare 16-02-22 3:34 PM C/In OverTime Out FOT
1154 SDS1154 Nutchare 17-02-22 6:51 AM C/In Invalid
1167 SDS1167 Manich 16-02-22 6:38 AM C/In OverTime In FOT
1167 SDS1167 Manich 16-02-22 4:03 PM C/Out OverTime Out FOT
1167 SDS1167 Manich 17-02-22 6:48 AM C/In Invalid
1169 SDS1169 Arthitiy 16-02-22 6:46 AM C/In OverTime In FOT
1169 SDS1169 Arthitiy 16-02-22 3:31 PM C/In OverTime Out FOT
1169 SDS1169 Arthitiy 17-02-22 6:51 AM C/In Invalid
1176 SDS1176 Wanwisa 16-02-22 2:52 PM C/In OverTime In FOT
1176 SDS1176 Wanwisa 16-02-22 11:34 PM OverTime Out FOT
1178 SDS1178 Waribtho 16-02-22 7:35 AM C/In OverTime In FOT
1178 SDS1178 Waribtho 16-02-22 5:10 PM C/Out OverTime Out FOT
1178 SDS1178 Waribtho 17-02-22 7:40 AM C/In Invalid
1181 SDS1181 Apivhate 16-02-22 7:33 PM C/Out OverTime In FOT
1181 SDS1181 Apivhate 17-02-22 5:02 AM OverTime Out FOT
1182 SDS1182 Athichat 16-02-22 6:31 AM C/Out OverTime In FOT
1182 SDS1182 Athichat 16-02-22 3:33 PM C/In OverTime Out FOT
1182 SDS1182 Athichat 17-02-22 6:37 AM C/In Invalid
1188 SDS1188 Chanit 16-02-22 2:36 PM C/In OverTime In FOT
1188 SDS1188 Chanit 16-02-22 11:31 PM C/In OverTime Out FOT
1189 SDS1189 Autchana 16-02-22 2:35 PM C/In OverTime In FOT
1189 SDS1189 Autchana 16-02-22 11:31 PM C/In OverTime Out FOT
1197 SDS1197 Unchalee 16-02-22 7:50 AM C/In OverTime In FOT
1197 SDS1197 Unchalee 16-02-22 5:09 PM C/Out OverTime Out FOT
1197 SDS1197 Unchalee 17-02-22 7:55 AM C/In Invalid
1199 SDS1199 Nicharee 16-02-22 7:34 AM C/In Invalid
1201 SDS1201 Niran 16-02-22 7:31 AM C/In Invalid
1203 SDS1203 Tarathon 16-02-22 2:30 PM C/In OverTime In FOT
1203 SDS1203 Tarathon 16-02-22 11:32 PM C/In OverTime Out FOT
1204 SDS1204 Sumrich 16-02-22 6:50 AM C/In OverTime In FOT
1204 SDS1204 Sumrich 16-02-22 3:34 PM C/In OverTime Out FOT
1204 SDS1204 Sumrich 17-02-22 6:51 AM C/In Invalid
1206 SDS1206 Thidarat 16-02-22 7:34 AM C/In Invalid
1206 SDS1206 Thidarat 16-02-22 10:47 PM C/In Invalid
1206 SDS1206 Thidarat 17-02-22 7:38 AM C/In Invalid
1207 SDS1207 Sudarat 16-02-22 6:41 AM C/In OverTime In FOT
1207 SDS1207 Sudarat 16-02-22 3:32 PM C/In OverTime Out FOT
1207 SDS1207 Sudarat 17-02-22 6:47 AM C/In Invalid
1212 SDS1212 Natchaph 16-02-22 7:50 AM C/In OverTime In FOT
1212 SDS1212 Natchaph 16-02-22 5:02 PM C/Out OverTime Out FOT
1212 SDS1212 Natchaph 16-02-22 5:03 PM C/Out Invalid
1212 SDS1212 Natchaph 17-02-22 7:56 AM C/In Invalid
1213 SDS1213 Nattapho 16-02-22 8:18 AM C/In OverTime In FOT
1213 SDS1213 Nattapho 16-02-22 5:01 PM C/Out OverTime Out FOT
1213 SDS1213 Nattapho 16-02-22 5:03 PM C/Out Invalid
1213 SDS1213 Nattapho 17-02-22 8:04 AM C/In Invalid
1216 SDS1216 Seksan 16-02-22 2:28 PM C/In OverTime In FOT
1216 SDS1216 Seksan 16-02-22 11:32 PM C/In OverTime Out FOT
1227 SDS1227 Suchat 16-02-22 7:02 AM C/In OverTime In FOT
1227 SDS1227 Suchat 16-02-22 3:32 PM C/In OverTime Out FOT
1227 SDS1227 Suchat 17-02-22 6:56 AM C/In Invalid
1234 SDS1234 Aekkapan 16-02-22 7:35 AM C/In Invalid
1234 SDS1234 Aekkapan 16-02-22 10:29 PM C/Out Invalid
1234 SDS1234 Aekkapan 17-02-22 7:41 AM C/In Invalid
กะทำงาน
ชื่อสถานะ "กะ" เวลาเข้า เวลาออก
P 17.00 PM 02.00 AM
E 15.00 PM 23.30 PM
S 20.00 PM 05.00 AM
N 23.00 PM 07.30 AM
M 07.00 AM 15.30 PM
D 08.00 AM 17.00 PM