ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBRBSBTBUBVBWBXBYBZCACBCCCDCECFCG
1
BẢNG CHẤM CÔNG THÁNG 04-2021 - Toàn công ty
2
3
5
No.CodeFull nameDepartmentPartStart dateDay shift/
Night shift
ThursdayFridaySaturdaySundayMondayThursdayWednesdayThursdayFridaySaturdaySundayMondayThursdayWednesdayThursdayFridaySaturdaySundayMondayThursdayWednesdayThursdayFridaySaturdaySundayMondayThursdayWednesdayThursdayFridayWorking DaysWorking in SundayWorking holiday OvertimesOvertime in SundayOvertime in holidayHoliday get salary Total Payment
6
010203040506070809101112131415161718192021222324252627282930
7
WDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveWDAnnual leaveDay timeNight timeDay timeNight timeDay timeNight timeDay timeNight timeDay timeNight timeDay timeNight timeLeave get 70% salaryTotal payment as normal daysTotal payment as night time
8
123456101216181618161816182224252725271618343637393739434546484648161855575860586064666769464816187678798179818587889088908890100101102103104105106107108109110111116117118119
9
5.50 - 5.50 - 5.75 - - - 5.00 - 5.00 - 5.00 - 4.50 - 6.00 - 6.00 - - - 6.00 - 6.00 - 6.00 - 6.00 - 5.50 - 5.88 - - - 6.00 - 6.00 - - - 6.00 - 5.75 - 6.00 - - - 6.00 - 6.00 - 6.00 - 5.00 - - - 136.38 - - - - - - - - - - - 12.00 - 151.38 -
10
1A1Administration 1Cleaner1/1/2020Day1.000.50P/21.001.001.001.000.50P/21.001.001.001.001.001.000.50P/21.001.001.00NL1.001.001.001.001.001.001.00NL 22.500 - - - - - - - - - - - 2.000 26.000 -
11
OTD
12
Night
13
OTN
14
2A2Administration 1HR1/1/2020Day1.001.000.75SP1.001.001.001.001.001.001.001.001.001.001.000.88SP1.001.00NL1.001.001.001.001.001.001.00NL 23.625 - - - - - - - - - - - 2.000 25.625 -
15
OTD
16
Night
17
OTN
18
3A3Administration 1HR1/1/2020DayMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLMLML - - - - - - - - - - - - - -
19
OTD
20
Night
21
OTN
22
4A4Administration 1HR1/1/2020Day0.50P/21.001.00SLSLSLSL1.001.001.001.001.001.001.001.001.001.00NL1.001.001.001.001.001.001.00NL 19.500 - - - - - - - - - - - 2.000 22.000 -
23
OTD
24
Night
25
OTN
26
5A5Administration 1HR1/1/2020Day1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.00NL1.000.75SP1.001.001.001.001.00NL 23.750 - - - - - - - - - - - 2.000 25.750 -
27
OTD
28
Night
29
OTN
30
6A6Administration 1HR1/1/2020Day1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.00NL1.001.001.001.001.001.001.00NL 24.000 - - - - - - - - - - - 2.000 26.000 -
31
OTD
32
Night
33
OTN
34
7A7Administration 1IT1/1/2020Day1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.00NL1.001.001.001.001.001.00PNL 23.000 - - - - - - - - - - - 2.000 26.000 -
35
OTD
36
Night
37
OTN
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101