{"id":11935,"date":"2026-05-10T08:49:14","date_gmt":"2026-05-10T01:49:14","guid":{"rendered":"https:\/\/arito.vn\/?p=11935"},"modified":"2026-09-13T00:18:38","modified_gmt":"2026-09-12T17:18:38","slug":"mau-bang-cham-cong-de-su-dung-va-hieu-qua","status":"publish","type":"post","link":"https:\/\/arito.vn\/en\/mau-bang-cham-cong-de-su-dung-va-hieu-qua\/","title":{"rendered":"12 M\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng h\u00e0ng ng\u00e0y k\u00e8m c\u00e1ch t\u00ednh l\u01b0\u01a1ng l\u00e0m th\u00eam gi\u1edd"},"content":{"rendered":"

B\u1ea3ng ch\u1ea5m c\u00f4ng t\u1ed3n t\u1ea1i \u0111\u1ec3 t\u00ednh ra ti\u1ec1n l\u01b0\u01a1ng. Nh\u01b0ng ph\u1ea7n l\u1edbn m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng l\u01b0u h\u00e0nh tr\u00ean m\u1ea1ng ch\u1ec9 \u0111\u1ebfm ng\u00e0y c\u00f4ng, kh\u00f4ng c\u00f3 ch\u1ed7 n\u00e0o ghi gi\u1edd l\u00e0m th\u00eam \u0111\u01b0\u1ee3c tr\u1ea3 theo t\u1ef7 l\u1ec7 n\u00e0o.<\/p>\n

B\u00e0i vi\u1ebft cung c\u1ea5p 12 m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng theo t\u1eebng t\u00ecnh hu\u1ed1ng, k\u00e8m b\u1ea3ng t\u1ef7 l\u1ec7 l\u01b0\u01a1ng l\u00e0m th\u00eam gi\u1edd v\u00e0 c\u00f4ng th\u1ee9c Excel t\u00ednh t\u1ef1 \u0111\u1ed9ng.<\/p>\n

B\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0 g\u00ec?<\/h2>\n

B\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0 ch\u1ee9ng t\u1eeb ghi nh\u1eadn th\u1eddi gian l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng, d\u00f9ng l\u00e0m c\u0103n c\u1ee9 t\u00ednh l\u01b0\u01a1ng, t\u00ednh c\u00e1c kho\u1ea3n tr\u00edch theo l\u01b0\u01a1ng v\u00e0 theo d\u00f5i vi\u1ec7c ch\u1ea5p h\u00e0nh n\u1ed9i quy lao \u0111\u1ed9ng.<\/p>\n

B\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0 \u0111\u1ea7u v\u00e0o c\u1ee7a ba vi\u1ec7c:<\/p>\n\n\n\n\n\n\n
\n

Vi\u1ec7c<\/p>\n<\/td>\n

\n

C\u1ea7n g\u00ec t\u1eeb b\u1ea3ng ch\u1ea5m c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

Payroll<\/p>\n<\/td>\n

\n

S\u1ed1 ng\u00e0y c\u00f4ng, s\u1ed1 gi\u1edd l\u00e0m th\u00eam theo t\u1eebng lo\u1ea1i<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u00f3ng b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

\n

S\u1ed1 ng\u00e0y c\u00f4ng th\u1ef1c t\u1ebf, ng\u00e0y ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng, ngh\u1ec9 ch\u1ebf \u0111\u1ed9<\/p>\n<\/td>\n<\/tr>\n

\n

Qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/p>\n<\/td>\n

\n

Ng\u00e0y ngh\u1ec9 trong n\u0103m, s\u1ed1 gi\u1edd l\u00e0m th\u00eam, l\u00e0m c\u0103n c\u1ee9 cho s\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00dd cu\u1ed1i li\u00ean quan \u0111\u1ebfn ngh\u0129a v\u1ee5 b\u1eaft bu\u1ed9c. S\u1ed5 qu\u1ea3n l\u00fd lao \u0111\u1ed9ng theo \u0110i\u1ec1u 3 Ngh\u1ecb \u0111\u1ecbnh 145\/2020\/N\u0110-CP c\u00f3 tr\u01b0\u1eddng v\u1ec1 s\u1ed1 ng\u00e0y ngh\u1ec9 trong n\u0103m v\u00e0 s\u1ed1 gi\u1edd l\u00e0m th\u00eam, v\u00e0 d\u1eef li\u1ec7u n\u00e0y l\u1ea5y t\u1eeb b\u1ea3ng ch\u1ea5m c\u00f4ng. Chi ti\u1ebft \u1edf b\u00e0i m\u1eabu danh s\u00e1ch nh\u00e2n vi\u00ean c\u00f4ng ty<\/span><\/a>.<\/p>\n

\"B\u1ea3ng<\/p>\n

Doanh nghi\u1ec7p c\u00f3 \u0111\u01b0\u1ee3c t\u1ef1 thi\u1ebft k\u1ebf b\u1ea3ng ch\u1ea5m c\u00f4ng kh\u00f4ng?<\/h2>\n

\u0110\u01b0\u1ee3c, v\u00e0 t\u1eeb n\u0103m 2026 quy\u1ec1n n\u00e0y c\u00f2n r\u1ed9ng h\u01a1n tr\u01b0\u1edbc.<\/p>\n

Tr\u01b0\u1edbc 01\/01\/2026:<\/b> Th\u00f4ng t\u01b0 200\/2014\/TT-BTC c\u00f3 m\u1eabu 01a-L\u0110TL cho b\u1ea3ng ch\u1ea5m c\u00f4ng, thu\u1ed9c nh\u00f3m ch\u1ee9ng t\u1eeb h\u01b0\u1edbng d\u1eabn ch\u1ee9 kh\u00f4ng b\u1eaft bu\u1ed9c.<\/p>\n

T\u1eeb 01\/01\/2026:<\/b> Th\u00f4ng t\u01b0 99\/2025\/TT-BTC thay th\u1ebf Th\u00f4ng t\u01b0 200. Th\u00f4ng t\u01b0 m\u1edbi cho ph\u00e9p doanh nghi\u1ec7p ch\u1ee7 \u0111\u1ed9ng thi\u1ebft k\u1ebf h\u1ec7 th\u1ed1ng ch\u1ee9ng t\u1eeb k\u1ebf to\u00e1n ph\u00f9 h\u1ee3p v\u1edbi \u0111\u1eb7c th\u00f9 ho\u1ea1t \u0111\u1ed9ng. Ph\u1ee5 l\u1ee5c I ban h\u00e0nh k\u00e8m Th\u00f4ng t\u01b0 c\u00f3 danh m\u1ee5c bi\u1ec3u m\u1eabu \u0111\u1ec3 doanh nghi\u1ec7p tham kh\u1ea3o \u00e1p d\u1ee5ng, kh\u00f4ng ph\u1ea3i m\u1eabu c\u1ee9ng b\u1eaft bu\u1ed9c.<\/p>\n

Nh\u00f3m bi\u1ec3u m\u1eabu lao \u0111\u1ed9ng ti\u1ec1n l\u01b0\u01a1ng t\u1ea1i Ph\u1ee5 l\u1ee5c I g\u1ed3m 8 m\u1eabu:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\n

M\u00e3 s\u1ed1<\/p>\n<\/td>\n

\n

T\u00ean bi\u1ec3u m\u1eabu<\/p>\n<\/td>\n<\/tr>\n

\n

01-L\u0110TL<\/p>\n<\/td>\n

\n

B\u1ea3ng thanh to\u00e1n ti\u1ec1n l\u01b0\u01a1ng<\/p>\n<\/td>\n<\/tr>\n

\n

02-L\u0110TL<\/p>\n<\/td>\n

\n

B\u1ea3ng thanh to\u00e1n ti\u1ec1n th\u01b0\u1edfng<\/p>\n<\/td>\n<\/tr>\n

\n

03-L\u0110TL<\/p>\n<\/td>\n

\n

B\u1ea3ng thanh to\u00e1n ti\u1ec1n l\u00e0m th\u00eam gi\u1edd<\/p>\n<\/td>\n<\/tr>\n

\n

04-L\u0110TL<\/p>\n<\/td>\n

\n

B\u1ea3ng thanh to\u00e1n ti\u1ec1n thu\u00ea ngo\u00e0i<\/p>\n<\/td>\n<\/tr>\n

\n

05-L\u0110TL<\/p>\n<\/td>\n

\n

H\u1ee3p \u0111\u1ed3ng giao kho\u00e1n<\/p>\n<\/td>\n<\/tr>\n

\n

06-L\u0110TL<\/p>\n<\/td>\n

\n

Bi\u00ean b\u1ea3n thanh l\u00fd h\u1ee3p \u0111\u1ed3ng giao kho\u00e1n<\/p>\n<\/td>\n<\/tr>\n

\n

07-L\u0110TL<\/p>\n<\/td>\n

\n

B\u1ea3ng k\u00ea tr\u00edch n\u1ed9p c\u00e1c kho\u1ea3n theo l\u01b0\u01a1ng<\/p>\n<\/td>\n<\/tr>\n

\n

08-L\u0110TL<\/p>\n<\/td>\n

\n

B\u1ea3ng ph\u00e2n b\u1ed5 ti\u1ec1n l\u01b0\u01a1ng v\u00e0 c\u00e1c kho\u1ea3n tr\u00edch<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

B\u1ea3ng ch\u1ea5m c\u00f4ng kh\u00f4ng n\u1eb1m trong danh m\u1ee5c n\u00e0y. Doanh nghi\u1ec7p t\u1ef1 thi\u1ebft k\u1ebf theo nhu c\u1ea7u.<\/p>\n

Nh\u01b0ng t\u1ef1 thi\u1ebft k\u1ebf kh\u00f4ng c\u00f3 ngh\u0129a l\u00e0 t\u00f9y ti\u1ec7n.<\/b> B\u1ea3ng ch\u1ea5m c\u00f4ng v\u1eabn l\u00e0 ch\u1ee9ng t\u1eeb ph\u1ee5c v\u1ee5 h\u1ea1ch to\u00e1n v\u00e0 c\u00f3 th\u1ec3 b\u1ecb y\u00eau c\u1ea7u xu\u1ea5t tr\u00ecnh khi thanh tra lao \u0111\u1ed9ng ho\u1eb7c quy\u1ebft to\u00e1n thu\u1ebf. B\u1ea3y n\u1ed9i dung t\u1ed1i thi\u1ec3u n\u00ean c\u00f3:<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

#<\/p>\n<\/td>\n

\n

Content<\/p>\n<\/td>\n<\/tr>\n

\n

1<\/p>\n<\/td>\n

\n

T\u00ean v\u00e0 \u0111\u1ecba ch\u1ec9 \u0111\u01a1n v\u1ecb, b\u1ed9 ph\u1eadn<\/p>\n<\/td>\n<\/tr>\n

\n

2<\/p>\n<\/td>\n

\n

T\u00ean ch\u1ee9ng t\u1eeb v\u00e0 k\u1ef3 ch\u1ea5m c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

3<\/p>\n<\/td>\n

\n

H\u1ecd t\u00ean v\u00e0 m\u00e3 s\u1ed1 c\u1ee7a t\u1eebng ng\u01b0\u1eddi lao \u0111\u1ed9ng<\/p>\n<\/td>\n<\/tr>\n

\n

4<\/p>\n<\/td>\n

\n

Ng\u00e0y c\u00f4ng theo t\u1eebng ng\u00e0y trong k\u1ef3, c\u00f3 k\u00fd hi\u1ec7u r\u00f5 r\u00e0ng<\/p>\n<\/td>\n<\/tr>\n

\n

5<\/p>\n<\/td>\n

\n

T\u1ed5ng h\u1ee3p s\u1ed1 c\u00f4ng theo t\u1eebng lo\u1ea1i \u1edf c\u1ed9t cu\u1ed1i<\/p>\n<\/td>\n<\/tr>\n

\n

6<\/p>\n<\/td>\n

\n

S\u1ed1 gi\u1edd l\u00e0m th\u00eam t\u00e1ch theo ng\u00e0y th\u01b0\u1eddng, ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n, ng\u00e0y l\u1ec5 t\u1ebft, ban \u0111\u00eam<\/p>\n<\/td>\n<\/tr>\n

\n

7<\/p>\n<\/td>\n

\n

Ch\u1eef k\u00fd c\u1ee7a ng\u01b0\u1eddi ch\u1ea5m c\u00f4ng, ph\u1ee5 tr\u00e1ch b\u1ed9 ph\u1eadn v\u00e0 ng\u01b0\u1eddi duy\u1ec7t<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00dd s\u1ed1 6 l\u00e0 \u00fd hay b\u1ecb thi\u1ebfu nh\u1ea5t, v\u00e0 c\u0169ng l\u00e0 \u00fd khi\u1ebfn b\u1ea3ng ch\u1ea5m c\u00f4ng kh\u00f4ng t\u00ednh \u0111\u01b0\u1ee3c l\u01b0\u01a1ng l\u00e0m th\u00eam gi\u1edd cho \u0111\u00fang.<\/p>\n

Doanh nghi\u1ec7p nh\u1ecf v\u00e0 v\u1eeba \u00e1p d\u1ee5ng Th\u00f4ng t\u01b0 133\/2016\/TT-BTC th\u00ec ch\u1ebf \u0111\u1ed9 n\u00e0y kh\u00f4ng thay \u0111\u1ed5i.<\/p>\n

B\u1ed9 k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng chu\u1ea9n<\/h2>\n

Ph\u1ea7n n\u00e0y b\u1ea3n c\u0169 kh\u00f4ng c\u00f3, d\u1eabn \u0111\u1ebfn m\u1ed7i b\u1ed9 ph\u1eadn d\u00f9ng m\u1ed9t ki\u1ec3u k\u00fd hi\u1ec7u v\u00e0 cu\u1ed1i th\u00e1ng kh\u00f4ng t\u1ed5ng h\u1ee3p \u0111\u01b0\u1ee3c b\u1eb1ng c\u00f4ng th\u1ee9c.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

K\u00fd hi\u1ec7u<\/p>\n<\/td>\n

\n

\u00dd ngh\u0129a<\/p>\n<\/td>\n

\n

T\u00ednh c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

X<\/p>\n<\/td>\n

\n

L\u00e0m vi\u1ec7c \u0111\u1ee7 gi\u1edd theo quy \u0111\u1ecbnh<\/p>\n<\/td>\n

\n

1 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

1\/2X ho\u1eb7c X\/2<\/p>\n<\/td>\n

\n

L\u00e0m vi\u1ec7c n\u1eeda ng\u00e0y<\/p>\n<\/td>\n

\n

0,5 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

P<\/p>\n<\/td>\n

\n

Ngh\u1ec9 ph\u00e9p n\u0103m c\u00f3 h\u01b0\u1edfng l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

1 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

L<\/p>\n<\/td>\n

\n

Ngh\u1ec9 l\u1ec5, t\u1ebft c\u00f3 h\u01b0\u1edfng l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

1 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

C\u0110<\/p>\n<\/td>\n

\n

Ngh\u1ec9 vi\u1ec7c ri\u00eang c\u00f3 h\u01b0\u1edfng l\u01b0\u01a1ng theo quy \u0111\u1ecbnh<\/p>\n<\/td>\n

\n

1 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

KL<\/p>\n<\/td>\n

\n

Ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

0 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

\u00d4<\/p>\n<\/td>\n

\n

Ngh\u1ec9 \u1ed1m, h\u01b0\u1edfng ch\u1ebf \u0111\u1ed9 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

\n

0 c\u00f4ng l\u01b0\u01a1ng, t\u00ednh ch\u1ebf \u0111\u1ed9 ri\u00eang<\/p>\n<\/td>\n<\/tr>\n

\n

CO<\/p>\n<\/td>\n

\n

Ngh\u1ec9 con \u1ed1m<\/p>\n<\/td>\n

\n

0 c\u00f4ng l\u01b0\u01a1ng, t\u00ednh ch\u1ebf \u0111\u1ed9 ri\u00eang<\/p>\n<\/td>\n<\/tr>\n

\n

TS<\/p>\n<\/td>\n

\n

Ngh\u1ec9 thai s\u1ea3n<\/p>\n<\/td>\n

\n

0 c\u00f4ng l\u01b0\u01a1ng, t\u00ednh ch\u1ebf \u0111\u1ed9 ri\u00eang<\/p>\n<\/td>\n<\/tr>\n

\n

TN<\/p>\n<\/td>\n

\n

Ngh\u1ec9 tai n\u1ea1n lao \u0111\u1ed9ng<\/p>\n<\/td>\n

\n

Theo ch\u1ebf \u0111\u1ed9<\/p>\n<\/td>\n<\/tr>\n

\n

NB<\/p>\n<\/td>\n

\n

Ngh\u1ec9 b\u00f9<\/p>\n<\/td>\n

\n

1 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

N<\/p>\n<\/td>\n

\n

Ng\u1eebng vi\u1ec7c<\/p>\n<\/td>\n

\n

Theo th\u1ecfa thu\u1eadn v\u00e0 quy \u0111\u1ecbnh<\/p>\n<\/td>\n<\/tr>\n

\n

CT<\/p>\n<\/td>\n

\n

\u0110i c\u00f4ng t\u00e1c<\/p>\n<\/td>\n

\n

1 c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110T<\/p>\n<\/td>\n

\n

\u0110i h\u1ecdc, \u0111\u00e0o t\u1ea1o<\/p>\n<\/td>\n

\n

Theo quy \u0111\u1ecbnh c\u1ee7a \u0111\u01a1n v\u1ecb<\/p>\n<\/td>\n<\/tr>\n

\n

KP<\/p>\n<\/td>\n

\n

Ngh\u1ec9 kh\u00f4ng ph\u00e9p<\/p>\n<\/td>\n

\n

0 c\u00f4ng, x\u1eed l\u00fd theo n\u1ed9i quy<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ba nguy\u00ean t\u1eafc khi d\u00f9ng k\u00fd hi\u1ec7u:<\/b><\/b><\/p>\n

Ban h\u00e0nh b\u1ed9 k\u00fd hi\u1ec7u th\u00e0nh v\u0103n b\u1ea3n k\u00e8m n\u1ed9i quy lao \u0111\u1ed9ng, kh\u00f4ng \u0111\u1ec3 m\u1ed7i ng\u01b0\u1eddi hi\u1ec3u m\u1ed9t ki\u1ec3u.<\/p>\n

Ghi ch\u00fa b\u1ea3ng k\u00fd hi\u1ec7u ngay tr\u00ean \u0111\u1ea7u file b\u1ea3ng ch\u1ea5m c\u00f4ng, \u0111\u1ec3 ng\u01b0\u1eddi ch\u1ea5m kh\u00f4ng ph\u1ea3i nh\u1edb.<\/p>\n

Ph\u00e2n bi\u1ec7t r\u00f5 ngh\u1ec9 c\u00f3 l\u01b0\u01a1ng v\u00e0 ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng, v\u00ec hai lo\u1ea1i n\u00e0y \u1ea3nh h\u01b0\u1edfng kh\u00e1c nhau \u0111\u1ebfn l\u01b0\u01a1ng v\u00e0 \u0111\u1ebfn m\u1ee9c \u0111\u00f3ng b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i.<\/p>\n

V\u1edbi gi\u1edd l\u00e0m th\u00eam, kh\u00f4ng d\u00f9ng k\u00fd hi\u1ec7u m\u00e0 ghi s\u1ed1 gi\u1edd<\/b>, v\u00e0 ph\u1ea3i t\u00e1ch th\u00e0nh c\u00e1c c\u1ed9t ri\u00eang theo lo\u1ea1i ng\u00e0y. L\u00fd do \u1edf ph\u1ea7n sau.<\/p>\n

Ti\u1ec1n l\u01b0\u01a1ng l\u00e0m th\u00eam gi\u1edd<\/h2>\n

\u0110\u00e2y l\u00e0 ph\u1ea7n quy\u1ebft \u0111\u1ecbnh thi\u1ebft k\u1ebf c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng, v\u00e0 l\u00e0 ph\u1ea7n c\u00e1c b\u00e0i vi\u1ebft v\u1ec1 ch\u1ee7 \u0111\u1ec1 n\u00e0y \u0111\u1ec1u b\u1ecf qua.<\/p>\n

T\u1ef7 l\u1ec7 theo \u0110i\u1ec1u 98 B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019<\/h3>\n

T\u00ednh tr\u00ean \u0111\u01a1n gi\u00e1 ti\u1ec1n l\u01b0\u01a1ng ho\u1eb7c ti\u1ec1n l\u01b0\u01a1ng th\u1ef1c tr\u1ea3 theo c\u00f4ng vi\u1ec7c \u0111ang l\u00e0m:<\/p>\n\n\n\n\n\n\n\n
\n

Tr\u01b0\u1eddng h\u1ee3p<\/p>\n<\/td>\n

\n

Ban ng\u00e0y<\/p>\n<\/td>\n

\n

Ban \u0111\u00eam<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m vi\u1ec7c b\u00ecnh th\u01b0\u1eddng<\/p>\n<\/td>\n

\n

100%<\/p>\n<\/td>\n

\n

130%<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam v\u00e0o ng\u00e0y th\u01b0\u1eddng<\/p>\n<\/td>\n

\n

\u00edt nh\u1ea5t 150%<\/b><\/b><\/p>\n<\/td>\n

\n

\u00edt nh\u1ea5t 210%<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam v\u00e0o ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n<\/p>\n<\/td>\n

\n

\u00edt nh\u1ea5t 200%<\/b><\/b><\/p>\n<\/td>\n

\n

\u00edt nh\u1ea5t 270%<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam v\u00e0o ng\u00e0y l\u1ec5, t\u1ebft, ng\u00e0y ngh\u1ec9 c\u00f3 h\u01b0\u1edfng l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

\u00edt nh\u1ea5t 300%<\/b><\/b><\/p>\n<\/td>\n

\n

\u00edt nh\u1ea5t 390%<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Gi\u1ea3i th\u00edch c\u00e1c con s\u1ed1 ban \u0111\u00eam:<\/b> ng\u01b0\u1eddi l\u00e0m vi\u1ec7c v\u00e0o ban \u0111\u00eam \u0111\u01b0\u1ee3c tr\u1ea3 th\u00eam \u00edt nh\u1ea5t 30%. Ng\u01b0\u1eddi l\u00e0m th\u00eam gi\u1edd v\u00e0o ban \u0111\u00eam \u0111\u01b0\u1ee3c tr\u1ea3 th\u00eam 20% t\u00ednh theo \u0111\u01a1n gi\u00e1 ti\u1ec1n l\u01b0\u01a1ng c\u1ee7a c\u00f4ng vi\u1ec7c l\u00e0m v\u00e0o ban ng\u00e0y c\u1ee7a ng\u00e0y t\u01b0\u01a1ng \u1ee9ng. C\u1ed9ng l\u1ea1i ra 210%, 270% v\u00e0 390%.<\/p>\n

Gi\u1edd ban \u0111\u00eam<\/b> theo \u0110i\u1ec1u 106 B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019 \u0111\u01b0\u1ee3c t\u00ednh t\u1eeb 22 gi\u1edd \u0111\u1ebfn 6 gi\u1edd s\u00e1ng h\u00f4m sau.<\/p>\n

L\u01b0u \u00fd v\u1edbi ng\u00e0y l\u1ec5 t\u1ebft:<\/b> m\u1ee9c 300% ch\u01b0a bao g\u1ed3m ti\u1ec1n l\u01b0\u01a1ng c\u1ee7a ng\u00e0y l\u1ec5 m\u00e0 ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u1eabn \u0111\u01b0\u1ee3c h\u01b0\u1edfng. Ng\u01b0\u1eddi h\u01b0\u1edfng l\u01b0\u01a1ng th\u00e1ng \u0111i l\u00e0m ng\u00e0y l\u1ec5 th\u1ef1c nh\u1eadn ph\u1ea7n l\u01b0\u01a1ng ng\u00e0y l\u1ec5 c\u1ed9ng th\u00eam ph\u1ea7n l\u00e0m th\u00eam gi\u1edd.<\/p>\n

C\u00e1c m\u1ee9c tr\u00ean l\u00e0 m\u1ee9c t\u1ed1i thi\u1ec3u. Doanh nghi\u1ec7p th\u1ecfa thu\u1eadn m\u1ee9c cao h\u01a1n th\u00ec \u00e1p d\u1ee5ng m\u1ee9c \u0111\u00e3 th\u1ecfa thu\u1eadn.<\/p>\n

V\u00ed d\u1ee5 t\u00ednh<\/h3>\n

Ng\u01b0\u1eddi lao \u0111\u1ed9ng l\u01b0\u01a1ng th\u00e1ng 10.000.000 \u0111\u1ed3ng, ch\u1ebf \u0111\u1ed9 26 ng\u00e0y c\u00f4ng m\u1ed7i th\u00e1ng, 8 gi\u1edd m\u1ed7i ng\u00e0y.<\/p>\n\n\n\n\n\n
\n

B\u01b0\u1edbc<\/p>\n<\/td>\n

\n

T\u00ednh to\u00e1n<\/p>\n<\/td>\n

\n

K\u1ebft qu\u1ea3<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ed1 gi\u1edd l\u00e0m vi\u1ec7c trong th\u00e1ng<\/p>\n<\/td>\n

\n

26 \u00d7 8<\/p>\n<\/td>\n

\n

208 gi\u1edd<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u01a1n gi\u00e1 ti\u1ec1n l\u01b0\u01a1ng gi\u1edd<\/p>\n<\/td>\n

\n

10.000.000 \u00f7 208<\/p>\n<\/td>\n

\n

48.077 \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ti\u1ec1n l\u00e0m th\u00eam gi\u1edd theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p:<\/h3>\n\n\n\n\n\n\n\n\n
\n

Tr\u01b0\u1eddng h\u1ee3p<\/p>\n<\/td>\n

\n

S\u1ed1 gi\u1edd<\/p>\n<\/td>\n

\n

C\u00e1ch t\u00ednh<\/p>\n<\/td>\n

\n

Th\u00e0nh ti\u1ec1n<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam ng\u00e0y th\u01b0\u1eddng, ban ng\u00e0y<\/p>\n<\/td>\n

\n

2<\/p>\n<\/td>\n

\n

48.077 \u00d7 150% \u00d7 2<\/p>\n<\/td>\n

\n

144.231 \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam ng\u00e0y th\u01b0\u1eddng, ban \u0111\u00eam<\/p>\n<\/td>\n

\n

2<\/p>\n<\/td>\n

\n

48.077 \u00d7 210% \u00d7 2<\/p>\n<\/td>\n

\n

201.923 \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n<\/p>\n<\/td>\n

\n

8<\/p>\n<\/td>\n

\n

48.077 \u00d7 200% \u00d7 8<\/p>\n<\/td>\n

\n

769.231 \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam ng\u00e0y l\u1ec5, ban ng\u00e0y<\/p>\n<\/td>\n

\n

8<\/p>\n<\/td>\n

\n

48.077 \u00d7 300% \u00d7 8<\/p>\n<\/td>\n

\n

1.153.846 \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam ng\u00e0y l\u1ec5, ban \u0111\u00eam<\/p>\n<\/td>\n

\n

4<\/p>\n<\/td>\n

\n

48.077 \u00d7 390% \u00d7 4<\/p>\n<\/td>\n

\n

750.000 \u0111\u1ed3ng<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ch\u00eanh l\u1ec7ch gi\u1eefa 2 gi\u1edd l\u00e0m th\u00eam ng\u00e0y th\u01b0\u1eddng ban ng\u00e0y v\u00e0 2 gi\u1edd ng\u00e0y th\u01b0\u1eddng ban \u0111\u00eam l\u00e0 g\u1ea7n 58.000 \u0111\u1ed3ng. B\u1ea3ng ch\u1ea5m c\u00f4ng g\u1ed9p chung m\u1ecdi gi\u1edd l\u00e0m th\u00eam v\u00e0o m\u1ed9t c\u1ed9t th\u00ec kh\u00f4ng t\u00ednh ra \u0111\u01b0\u1ee3c con s\u1ed1 \u0111\u00fang.<\/p>\n

\u0110\u00e2y l\u00e0 l\u00fd do b\u1ea3ng ch\u1ea5m c\u00f4ng ph\u1ea3i t\u00e1ch t\u1ed1i thi\u1ec3u 5 c\u1ed9t gi\u1edd l\u00e0m th\u00eam:<\/b> ng\u00e0y th\u01b0\u1eddng ban ng\u00e0y, ng\u00e0y th\u01b0\u1eddng ban \u0111\u00eam, ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n, ng\u00e0y l\u1ec5 t\u1ebft, v\u00e0 l\u00e0m th\u00eam ban \u0111\u00eam c\u1ee7a ng\u00e0y ngh\u1ec9 ho\u1eb7c ng\u00e0y l\u1ec5.<\/p>\n

Gi\u1edbi h\u1ea1n gi\u1edd l\u00e0m th\u00eam theo \u0110i\u1ec1u 107<\/h2>\n\n\n\n\n\n\n\n\n
\n

Gi\u1edbi h\u1ea1n<\/p>\n<\/td>\n

\n

M\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

Trong m\u1ed9t ng\u00e0y<\/p>\n<\/td>\n

\n

Kh\u00f4ng qu\u00e1 50% s\u1ed1 gi\u1edd l\u00e0m vi\u1ec7c b\u00ecnh th\u01b0\u1eddng trong ng\u00e0y<\/p>\n<\/td>\n<\/tr>\n

\n

Theo tu\u1ea7n<\/p>\n<\/td>\n

\n

T\u1ed5ng gi\u1edd l\u00e0m vi\u1ec7c b\u00ecnh th\u01b0\u1eddng v\u00e0 gi\u1edd l\u00e0m th\u00eam kh\u00f4ng qu\u00e1 12 gi\u1edd m\u1ed7i ng\u00e0y<\/p>\n<\/td>\n<\/tr>\n

\n

Trong m\u1ed9t th\u00e1ng<\/p>\n<\/td>\n

\n

Kh\u00f4ng qu\u00e1 40 gi\u1edd<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Trong m\u1ed9t n\u0103m<\/p>\n<\/td>\n

\n

Kh\u00f4ng qu\u00e1 200 gi\u1edd<\/b><\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t theo quy \u0111\u1ecbnh<\/p>\n<\/td>\n

\n

Kh\u00f4ng qu\u00e1 300 gi\u1edd m\u1ed7i n\u0103m<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ngo\u00e0i ra, l\u00e0m th\u00eam gi\u1edd ph\u1ea3i c\u00f3 s\u1ef1 \u0111\u1ed3ng \u00fd c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng.<\/p>\n

C\u00e1ch \u0111\u01b0a gi\u1edbi h\u1ea1n v\u00e0o b\u1ea3ng ch\u1ea5m c\u00f4ng:<\/b> th\u00eam hai c\u1ed9t \u1edf ph\u1ea7n t\u1ed5ng h\u1ee3p, m\u1ed9t c\u1ed9t c\u1ed9ng gi\u1edd l\u00e0m th\u00eam trong th\u00e1ng v\u00e0 m\u1ed9t c\u1ed9t c\u1ed9ng l\u0169y k\u1ebf t\u1eeb \u0111\u1ea7u n\u0103m, k\u00e8m c\u00f4ng th\u1ee9c c\u1ea3nh b\u00e1o khi ch\u1ea1m ng\u01b0\u1ee1ng. C\u00f4ng th\u1ee9c c\u00f3 \u1edf ph\u1ea7n d\u01b0\u1edbi.<\/p>\n

Doanh nghi\u1ec7p v\u01b0\u1ee3t tr\u1ea7n gi\u1edd l\u00e0m th\u00eam c\u00f3 th\u1ec3 b\u1ecb x\u1eed ph\u1ea1t vi ph\u1ea1m h\u00e0nh ch\u00ednh, v\u00e0 \u0111\u00e2y l\u00e0 n\u1ed9i dung thanh tra lao \u0111\u1ed9ng th\u01b0\u1eddng ki\u1ec3m tra.<\/p>\n

12 m\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng<\/h2>\n

Nh\u00f3m 1: B\u1ea3ng ch\u1ea5m c\u00f4ng c\u01a1 b\u1ea3n<\/h3>\n

M\u1eabu 1: B\u1ea3ng ch\u1ea5m c\u00f4ng h\u00e0ng ng\u00e0y theo th\u00e1ng (Excel)<\/b><\/b><\/h4>\n

M\u1eabu d\u00f9ng ph\u1ed5 bi\u1ebfn nh\u1ea5t. M\u1ed7i ng\u01b0\u1eddi m\u1ed9t d\u00f2ng, m\u1ed7i ng\u00e0y trong th\u00e1ng m\u1ed9t c\u1ed9t, \u00f4 giao nhau ghi k\u00fd hi\u1ec7u.<\/p>\n\n\n\n\n\n\n\n\n
\n

Ph\u1ea7n<\/p>\n<\/td>\n

\n

C\u1ed9t<\/p>\n<\/td>\n<\/tr>\n

\n

\u0110\u1ea7u b\u1ea3ng<\/p>\n<\/td>\n

\n

STT, M\u00e3 nh\u00e2n vi\u00ean, H\u1ecd v\u00e0 t\u00ean, Ch\u1ee9c danh, B\u1ed9 ph\u1eadn<\/p>\n<\/td>\n<\/tr>\n

\n

Th\u00e2n b\u1ea3ng<\/p>\n<\/td>\n

\n

31 c\u1ed9t t\u01b0\u01a1ng \u1ee9ng 31 ng\u00e0y, ghi k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng<\/p>\n<\/td>\n<\/tr>\n

\n

T\u1ed5ng h\u1ee3p<\/p>\n<\/td>\n

\n

C\u00f4ng h\u01b0\u1edfng l\u01b0\u01a1ng th\u1eddi gian, C\u00f4ng ngh\u1ec9 ph\u00e9p, C\u00f4ng ngh\u1ec9 l\u1ec5, C\u00f4ng ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng, C\u00f4ng h\u01b0\u1edfng b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n<\/tr>\n

\n

L\u00e0m th\u00eam gi\u1edd<\/p>\n<\/td>\n

\n

5 c\u1ed9t theo lo\u1ea1i \u0111\u00e3 n\u00eau \u1edf ph\u1ea7n tr\u00ean<\/p>\n<\/td>\n<\/tr>\n

\n

Cu\u1ed1i b\u1ea3ng<\/p>\n<\/td>\n

\n

T\u1ed5ng c\u1ed9ng, Ghi ch\u00fa<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

N\u00ean \u0111\u1eb7t m\u00e0u n\u1ec1n kh\u00e1c cho c\u1ed9t ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n v\u00e0 ng\u00e0y l\u1ec5 \u0111\u1ec3 ng\u01b0\u1eddi ch\u1ea5m kh\u00f4ng nh\u1ea7m lo\u1ea1i gi\u1edd l\u00e0m th\u00eam.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng h\u00e0ng ng\u00e0y!<\/strong><\/span><\/a><\/p>\n

<\/p>\n

M\u1eabu 2: B\u1ea3ng ch\u1ea5m c\u00f4ng h\u00e0ng ng\u00e0y b\u1ea3n Word<\/b><\/b><\/h4>\n

D\u00f9ng khi c\u1ea7n in ra treo t\u1ea1i x\u01b0\u1edfng ho\u1eb7c t\u1ea1i b\u1ed9 ph\u1eadn \u0111\u1ec3 ch\u1ea5m tay, sau \u0111\u00f3 nh\u1eadp l\u1ea1i v\u00e0o Excel. Ph\u00f9 h\u1ee3p v\u1edbi \u0111\u01a1n v\u1ecb ch\u01b0a c\u00f3 m\u00e1y ch\u1ea5m c\u00f4ng v\u00e0 b\u1ed9 ph\u1eadn kh\u00f4ng d\u00f9ng m\u00e1y t\u00ednh.<\/p>\n

B\u1ea3n Word n\u00ean r\u00fat g\u1ecdn, ch\u1ec9 gi\u1eef ph\u1ea7n ch\u1ea5m k\u00fd hi\u1ec7u theo ng\u00e0y v\u00e0 c\u1ed9t t\u1ed5ng, b\u1ecf ph\u1ea7n t\u00ednh to\u00e1n. Kh\u1ed5 ngang A4 ho\u1eb7c A3 t\u00f9y s\u1ed1 ng\u01b0\u1eddi.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng h\u00e0ng ng\u00e0y b\u1eb1ng Word!<\/strong><\/span><\/a><\/p>\n

\"Mau-bang-cham-cong-hang-ngay-bang-WordM\u1eabu<\/p>\n

M\u1eabu 3: B\u1ea3ng ch\u1ea5m c\u00f4ng theo tu\u1ea7n<\/b><\/b><\/h4>\n

D\u00f9ng cho \u0111\u01a1n v\u1ecb tr\u1ea3 l\u01b0\u01a1ng theo tu\u1ea7n, ho\u1eb7c c\u00f4ng vi\u1ec7c ng\u1eafn h\u1ea1n theo \u0111\u1ee3t. C\u1ea5u tr\u00fac gi\u1ed1ng m\u1eabu 1 nh\u01b0ng ch\u1ec9 7 c\u1ed9t ng\u00e0y, th\u00eam d\u00f2ng t\u1ed5ng theo tu\u1ea7n.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng theo tu\u1ea7n!<\/strong><\/span><\/a><\/p>\n

\"M\u1eabu<\/p>\n

Nh\u00f3m 2: B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd<\/h3>\n

M\u1eabu 4: B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd v\u00e0o ra<\/b><\/b><\/h4>\n

D\u00f9ng khi c\u1ea7n t\u00ednh l\u01b0\u01a1ng theo gi\u1edd th\u1ef1c t\u1ebf ch\u1ee9 kh\u00f4ng theo ng\u00e0y c\u00f4ng.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

\n

Ghi ch\u00fa<\/p>\n<\/td>\n<\/tr>\n

\n

Ng\u00e0y<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Gi\u1edd v\u00e0o<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng gi\u1edd<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edd ra<\/p>\n<\/td>\n

\n

\u0110\u1ecbnh d\u1ea1ng gi\u1edd<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edd ngh\u1ec9 tr\u01b0a<\/p>\n<\/td>\n

\n

Tr\u1eeb ra kh\u1ecfi t\u1ed5ng<\/p>\n<\/td>\n<\/tr>\n

\n

T\u1ed5ng gi\u1edd l\u00e0m<\/p>\n<\/td>\n

\n

C\u00f4ng th\u1ee9c<\/p>\n<\/td>\n<\/tr>\n

\n

Trong \u0111\u00f3 gi\u1edd ban \u0111\u00eam<\/p>\n<\/td>\n

\n

C\u00f4ng th\u1ee9c, t\u00ednh ph\u1ea7n r\u01a1i v\u00e0o 22h \u0111\u1ebfn 6h<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edd l\u00e0m th\u00eam<\/p>\n<\/td>\n

\n

C\u00f4ng th\u1ee9c, ph\u1ea7n v\u01b0\u1ee3t gi\u1edd chu\u1ea9n<\/p>\n<\/td>\n<\/tr>\n

\n

Ghi ch\u00fa<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u1ed9t gi\u1edd ban \u0111\u00eam l\u00e0 c\u1ed9t kh\u00f3 nh\u1ea5t v\u00e0 c\u0169ng l\u00e0 c\u1ed9t h\u1ea7u h\u1ebft file m\u1eabu tr\u00ean m\u1ea1ng b\u1ecf qua ho\u1eb7c t\u00ednh sai.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd!<\/strong><\/span><\/a><\/p>\n

\"M\u1eabu<\/p>\n

M\u1eabu 5: B\u1ea3ng ch\u1ea5m c\u00f4ng theo ca<\/b><\/b><\/h4>\n

D\u00f9ng cho \u0111\u01a1n v\u1ecb s\u1ea3n xu\u1ea5t ch\u1ea1y nhi\u1ec1u ca.<\/p>\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u00e0y, H\u1ecd t\u00ean<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ca l\u00e0m<\/p>\n<\/td>\n

\n

Ca 1, ca 2, ca 3 ho\u1eb7c theo m\u00e3 ca c\u1ee7a \u0111\u01a1n v\u1ecb<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edd b\u1eaft \u0111\u1ea7u, Gi\u1edd k\u1ebft th\u00fac<\/p>\n<\/td>\n

\n

L\u1ea5y theo \u0111\u1ecbnh ngh\u0129a ca<\/p>\n<\/td>\n<\/tr>\n

\n

C\u00f3 l\u00e0m qua \u0111\u00eam kh\u00f4ng<\/p>\n<\/td>\n

\n

\u1ea2nh h\u01b0\u1edfng c\u00e1ch t\u00ednh<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ed1 gi\u1edd ban ng\u00e0y, S\u1ed1 gi\u1edd ban \u0111\u00eam<\/p>\n<\/td>\n

\n

T\u00e1ch ri\u00eang<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edd l\u00e0m th\u00eam trong ca<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

N\u00ean c\u00f3 m\u1ed9t sheet ri\u00eang \u0111\u1ecbnh ngh\u0129a c\u00e1c ca, g\u1ed3m m\u00e3 ca, gi\u1edd b\u1eaft \u0111\u1ea7u, gi\u1edd k\u1ebft th\u00fac, s\u1ed1 gi\u1edd ban \u0111\u00eam ch\u1ee9a trong ca. B\u1ea3ng ch\u1ea5m c\u00f4ng ch\u1ec9 ghi m\u00e3 ca, ph\u1ea7n c\u00f2n l\u1ea1i tra t\u1ef1 \u0111\u1ed9ng. C\u00e1ch n\u00e0y nhanh h\u01a1n v\u00e0 \u00edt sai h\u01a1n nh\u1eadp gi\u1edd t\u1eebng ng\u00e0y.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng theo ca!<\/strong><\/span><\/a><\/p>\n

\"M\u1eabu<\/p>\n

M\u1eabu 6: B\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd ri\u00eang<\/b><\/b><\/h4>\n

D\u00f9ng k\u00e8m b\u1ea3ng ch\u1ea5m c\u00f4ng ch\u00ednh, ghi chi ti\u1ebft t\u1eebng l\u1ea7n l\u00e0m th\u00eam.<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u00e0y, H\u1ecd t\u00ean, B\u1ed9 ph\u1eadn<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Lo\u1ea1i ng\u00e0y<\/p>\n<\/td>\n

\n

Ng\u00e0y th\u01b0\u1eddng, ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n, ng\u00e0y l\u1ec5 t\u1ebft<\/p>\n<\/td>\n<\/tr>\n

\n

Gi\u1edd b\u1eaft \u0111\u1ea7u, Gi\u1edd k\u1ebft th\u00fac<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

S\u1ed1 gi\u1edd ban ng\u00e0y, S\u1ed1 gi\u1edd ban \u0111\u00eam<\/p>\n<\/td>\n

\n

T\u00e1ch ri\u00eang<\/p>\n<\/td>\n<\/tr>\n

\n

T\u1ef7 l\u1ec7 \u00e1p d\u1ee5ng<\/p>\n<\/td>\n

\n

Tra theo b\u1ea3ng t\u1ef7 l\u1ec7<\/p>\n<\/td>\n<\/tr>\n

\n

N\u1ed9i dung c\u00f4ng vi\u1ec7c<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Ng\u01b0\u1eddi \u0111\u1ec1 ngh\u1ecb, Ng\u01b0\u1eddi duy\u1ec7t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Hai c\u1ed9t cu\u1ed1i quan tr\u1ecdng v\u1ec1 m\u1eb7t ph\u00e1p l\u00fd, v\u00ec l\u00e0m th\u00eam gi\u1edd ph\u1ea3i c\u00f3 s\u1ef1 \u0111\u1ed3ng \u00fd c\u1ee7a ng\u01b0\u1eddi lao \u0111\u1ed9ng. B\u1ea3ng c\u00f3 ch\u1ed7 k\u00fd l\u00e0 b\u1eb1ng ch\u1ee9ng cho vi\u1ec7c \u0111\u00f3.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng l\u00e0m th\u00eam gi\u1edd!<\/strong><\/span><\/a><\/p>\n

\"M\u1eabu<\/p>\n

9. M\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng theo tu\u1ea7n<\/b><\/h2>\n

Nh\u00f3m 3: B\u1ea3ng ch\u1ea5m c\u00f4ng theo \u0111\u1eb7c th\u00f9<\/h3>\n

M\u1eabu 7: B\u1ea3ng ch\u1ea5m c\u00f4ng s\u1ea3n xu\u1ea5t theo t\u1ed5, theo chuy\u1ec1n<\/b><\/b><\/h4>\n

Th\u00eam c\u1ed9t t\u1ed5, chuy\u1ec1n, s\u1ea3n ph\u1ea9m \u0111ang ch\u1ea1y. D\u00f9ng khi c\u1ea7n ph\u00e2n b\u1ed5 chi ph\u00ed nh\u00e2n c\u00f4ng v\u00e0o gi\u00e1 th\u00e0nh theo t\u1eebng l\u1ec7nh s\u1ea3n xu\u1ea5t. Xem th\u00eam b\u00e0i chi ph\u00ed s\u1ea3n xu\u1ea5t<\/span><\/a>.<\/p>\n

C\u1ed9t c\u1ea7n th\u00eam: M\u00e3 l\u1ec7nh s\u1ea3n xu\u1ea5t, C\u00f4ng \u0111o\u1ea1n, S\u1ed1 gi\u1edd l\u00e0m cho t\u1eebng l\u1ec7nh. C\u00f3 c\u1ed9t n\u00e0y th\u00ec chi ph\u00ed nh\u00e2n c\u00f4ng \u0111i th\u1eb3ng v\u00e0o gi\u00e1 th\u00e0nh t\u1eebng \u0111\u01a1n h\u00e0ng thay v\u00ec ph\u00e2n b\u1ed5 \u01b0\u1edbc l\u01b0\u1ee3ng.<\/p>\n

T\u1ea3i ngay!<\/a><\/p>\n

M\u1eabu 8: B\u1ea3ng ch\u1ea5m c\u00f4ng c\u00f4ng tr\u01b0\u1eddng, nh\u00e2n vi\u00ean thi c\u00f4ng<\/b><\/b><\/h4>\n

Th\u00eam c\u1ed9t s\u1ed1 th\u1ebb, t\u1ed5 \u0111\u1ed9i, h\u1ea1ng m\u1ee5c c\u00f4ng vi\u1ec7c, v\u00e0 c\u1ed9t x\u00e1c nh\u1eadn c\u1ee7a gi\u00e1m s\u00e1t. Th\u01b0\u1eddng ph\u1ea3i n\u1ed9p cho ch\u1ee7 \u0111\u1ea7u t\u01b0 n\u00ean c\u1ea7n ch\u1ed7 k\u00fd x\u00e1c nh\u1eadn c\u1ee7a c\u1ea3 hai b\u00ean.<\/p>\n

T\u1ea3i ngay!<\/a><\/p>\n

M\u1eabu 9: B\u1ea3ng ch\u1ea5m c\u00f4ng nh\u00e2n vi\u00ean b\u00e1n th\u1eddi gian<\/b><\/b><\/h4>\n

Ng\u01b0\u1eddi l\u00e0m b\u00e1n th\u1eddi gian th\u01b0\u1eddng kh\u00f4ng t\u00ednh theo ng\u00e0y c\u00f4ng m\u00e0 theo ca ho\u1eb7c theo gi\u1edd. B\u1ea3ng n\u00ean c\u00f3 c\u1ed9t m\u00e3 ca, s\u1ed1 gi\u1edd m\u1ed7i ca, \u0111\u01a1n gi\u00e1 gi\u1edd, th\u00e0nh ti\u1ec1n.<\/p>\n

L\u01b0u \u00fd: ng\u01b0\u1eddi lao \u0111\u1ed9ng b\u00e1n th\u1eddi gian v\u1eabn thu\u1ed9c ph\u1ea1m vi \u0111i\u1ec1u ch\u1ec9nh c\u1ee7a quy \u0111\u1ecbnh v\u1ec1 l\u00e0m th\u00eam gi\u1edd v\u00e0 l\u00e0m vi\u1ec7c ban \u0111\u00eam.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng part-time!<\/a><\/strong><\/p>\n

\"b\u1ea3ng<\/p>\n

M\u1eabu 10: B\u1ea3ng ch\u1ea5m c\u00f4ng gi\u00e1o vi\u00ean theo s\u1ed1 ti\u1ebft d\u1ea1y<\/b><\/b><\/h4>\n

D\u00f9ng cho c\u01a1 s\u1edf gi\u00e1o d\u1ee5c, ghi theo ti\u1ebft thay v\u00ec theo gi\u1edd. C\u1ed9t g\u1ed3m ng\u00e0y, l\u1edbp, m\u00f4n, s\u1ed1 ti\u1ebft, lo\u1ea1i ti\u1ebft (ch\u00ednh kh\u00f3a, t\u0103ng c\u01b0\u1eddng, d\u1ea1y thay), v\u00e0 c\u1ed9t quy \u0111\u1ed5i ra gi\u1edd chu\u1ea9n.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng h\u00e0ng ng\u00e0y gi\u00e1o vi\u00ean!<\/strong><\/span><\/a><\/p>\n

\"M\u1eabu<\/p>\n

Nh\u00f3m 4: B\u1ea3ng ch\u1ea5m c\u00f4ng ph\u1ee5c v\u1ee5 m\u1ee5c \u0111\u00edch kh\u00e1c<\/h3>\n

M\u1eabu 11: B\u1ea3ng ch\u1ea5m c\u00f4ng song ng\u1eef<\/b><\/b><\/h4>\n

D\u00f9ng cho doanh nghi\u1ec7p c\u00f3 v\u1ed1n n\u01b0\u1edbc ngo\u00e0i ho\u1eb7c c\u00f3 lao \u0111\u1ed9ng n\u01b0\u1edbc ngo\u00e0i. Gi\u1eef nguy\u00ean c\u1ea5u tr\u00fac m\u1eabu 1, th\u00eam d\u00f2ng ti\u00eau \u0111\u1ec1 ti\u1ebfng Anh d\u01b0\u1edbi m\u1ed7i ti\u00eau \u0111\u1ec1 ti\u1ebfng Vi\u1ec7t. B\u1ea3ng k\u00fd hi\u1ec7u c\u0169ng c\u1ea7n b\u1ea3n song ng\u1eef.<\/p>\n

T\u1ea3i ngay b\u1ea3ng ch\u1ea5m c\u00f4ng song ng\u1eef<\/strong><\/span><\/a><\/p>\n

\"M\u1eabu<\/p>\n

M\u1eabu 12: B\u1ea3ng t\u1ed5ng h\u1ee3p ch\u1ea5m c\u00f4ng to\u00e0n c\u00f4ng ty<\/b><\/b><\/h4>\n

Kh\u00f4ng ph\u1ea3i b\u1ea3ng ch\u1ea5m c\u00f4ng m\u00e0 l\u00e0 b\u1ea3ng t\u1ed5ng h\u1ee3p t\u1eeb c\u00e1c b\u1ed9 ph\u1eadn, d\u00f9ng l\u00e0m \u0111\u1ea7u v\u00e0o cho b\u1ea3ng thanh to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

C\u1ed9t<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

B\u1ed9 ph\u1eadn, M\u00e3 nh\u00e2n vi\u00ean, H\u1ecd t\u00ean<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

T\u1ed5ng c\u00f4ng h\u01b0\u1edfng l\u01b0\u01a1ng th\u1eddi gian<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

T\u1ed5ng c\u00f4ng ngh\u1ec9 h\u01b0\u1edfng l\u01b0\u01a1ng<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

T\u1ed5ng c\u00f4ng ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

T\u1ed5ng c\u00f4ng h\u01b0\u1edfng b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

Gi\u1edd l\u00e0m th\u00eam theo 5 lo\u1ea1i<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

L\u0169y k\u1ebf gi\u1edd l\u00e0m th\u00eam t\u1eeb \u0111\u1ea7u n\u0103m<\/p>\n<\/td>\n

\n

\u0110\u1ec3 theo d\u00f5i tr\u1ea7n 200 gi\u1edd<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

T\u1ea3i ngay!<\/a><\/p>\n

B\u1ea3ng ch\u1ecdn m\u1eabu theo t\u00ecnh hu\u1ed1ng<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

T\u00ecnh hu\u1ed1ng<\/p>\n<\/td>\n

\n

M\u1eabu n\u00ean d\u00f9ng<\/p>\n<\/td>\n<\/tr>\n

\n

V\u0103n ph\u00f2ng, gi\u1edd h\u00e0nh ch\u00ednh c\u1ed1 \u0111\u1ecbnh<\/p>\n<\/td>\n

\n

M\u1eabu 1<\/p>\n<\/td>\n<\/tr>\n

\n

Ch\u01b0a c\u00f3 m\u00e1y ch\u1ea5m c\u00f4ng, ch\u1ea5m tay t\u1ea1i b\u1ed9 ph\u1eadn<\/p>\n<\/td>\n

\n

M\u1eabu 2 k\u1ebft h\u1ee3p m\u1eabu 1<\/p>\n<\/td>\n<\/tr>\n

\n

Tr\u1ea3 l\u01b0\u01a1ng theo gi\u1edd<\/p>\n<\/td>\n

\n

M\u1eabu 4<\/p>\n<\/td>\n<\/tr>\n

\n

S\u1ea3n xu\u1ea5t ch\u1ea1y ca, c\u00f3 ca \u0111\u00eam<\/p>\n<\/td>\n

\n

M\u1eabu 5 k\u1ebft h\u1ee3p m\u1eabu 6<\/p>\n<\/td>\n<\/tr>\n

\n

C\u1ea7n t\u00ednh chi ph\u00ed nh\u00e2n c\u00f4ng v\u00e0o gi\u00e1 th\u00e0nh t\u1eebng \u0111\u01a1n h\u00e0ng<\/p>\n<\/td>\n

\n

M\u1eabu 7<\/p>\n<\/td>\n<\/tr>\n

\n

Nh\u00e2n s\u1ef1 t\u1ea1i c\u00f4ng tr\u01b0\u1eddng<\/p>\n<\/td>\n

\n

M\u1eabu 8<\/p>\n<\/td>\n<\/tr>\n

\n

C\u1eeda h\u00e0ng, qu\u00e1n, nh\u00e2n vi\u00ean theo ca ng\u1eafn<\/p>\n<\/td>\n

\n

M\u1eabu 9<\/p>\n<\/td>\n<\/tr>\n

\n

Doanh nghi\u1ec7p c\u00f3 lao \u0111\u1ed9ng n\u01b0\u1edbc ngo\u00e0i<\/p>\n<\/td>\n

\n

M\u1eabu 11<\/p>\n<\/td>\n<\/tr>\n

\n

Nhi\u1ec1u b\u1ed9 ph\u1eadn, c\u1ea7n t\u1ed5ng h\u1ee3p tr\u01b0\u1edbc khi t\u00ednh l\u01b0\u01a1ng<\/p>\n<\/td>\n

\n

M\u1eabu 12<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u00f4ng th\u1ee9c Excel cho b\u1ea3ng ch\u1ea5m c\u00f4ng<\/h2>\n

Nh\u00f3m c\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00f4ng<\/h3>\n

Gi\u1ea3 \u0111\u1ecbnh v\u00f9ng ch\u1ea5m c\u00f4ng c\u1ee7a m\u1ed9t ng\u01b0\u1eddi l\u00e0 F5:AJ5 (31 ng\u00e0y).<\/p>\n

\u0110\u1ebfm c\u00f4ng h\u01b0\u1edfng l\u01b0\u01a1ng th\u1eddi gian,<\/b> t\u00ednh c\u1ea3 n\u1eeda ng\u00e0y:<\/p>\n

=COUNTIF(F5:AJ5,”X”)+COUNTIF(F5:AJ5,”X\/2″)*0.5<\/p>\n

\u0110\u1ebfm c\u00f4ng ngh\u1ec9 ph\u00e9p:<\/b><\/b><\/p>\n

=COUNTIF(F5:AJ5,”P”)<\/p>\n

\u0110\u1ebfm c\u00f4ng ngh\u1ec9 h\u01b0\u1edfng b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i,<\/b> g\u1ed9p nhi\u1ec1u k\u00fd hi\u1ec7u:<\/p>\n

=SUMPRODUCT(COUNTIF(F5:AJ5,{“\u00d4”;”CO”;”TS”;”TN”}))<\/p>\n

\u0110\u1ebfm c\u00f4ng ngh\u1ec9 kh\u00f4ng l\u01b0\u01a1ng:<\/b><\/b><\/p>\n

=COUNTIF(F5:AJ5,”KL”)+COUNTIF(F5:AJ5,”KP”)<\/p>\n

Nh\u00f3m c\u00f4ng th\u1ee9c t\u00ednh gi\u1edd<\/h3>\n

T\u1ed5ng gi\u1edd l\u00e0m trong ng\u00e0y,<\/b> C5 l\u00e0 gi\u1edd v\u00e0o, D5 l\u00e0 gi\u1edd ra, E5 l\u00e0 gi\u1edd ngh\u1ec9 tr\u01b0a t\u00ednh b\u1eb1ng gi\u1edd:<\/p>\n

=IF(OR(C5=””,D5=””),””,(D5-C5)*24-E5)<\/p>\n

T\u00ednh gi\u1edd l\u00e0m khi ca qua \u0111\u00eam,<\/b> tr\u01b0\u1eddng h\u1ee3p gi\u1edd ra nh\u1ecf h\u01a1n gi\u1edd v\u00e0o:<\/p>\n

=IF(OR(C5=””,D5=””),””,IF(D5<C5,(D5+1-C5)*24,(D5-C5)*24)-E5)<\/p>\n

\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u00e0 ph\u1ea7n l\u1edbn file m\u1eabu tr\u00ean m\u1ea1ng thi\u1ebfu. Ca t\u1eeb 22h h\u00f4m tr\u01b0\u1edbc \u0111\u1ebfn 6h h\u00f4m sau, n\u1ebfu d\u00f9ng c\u00f4ng th\u1ee9c th\u01b0\u1eddng s\u1ebd ra s\u1ed1 \u00e2m.<\/p>\n

T\u00ednh s\u1ed1 gi\u1edd r\u01a1i v\u00e0o khung ban \u0111\u00eam t\u1eeb 22h \u0111\u1ebfn 6h,<\/b> v\u1edbi ca kh\u00f4ng qu\u00e1 24 gi\u1edd:<\/p>\n

=MAX(0,MIN(IF(D5<C5,D5+1,D5),6\/24+1)-MAX(C5,22\/24))*24
\n<\/span> + MAX(0,MIN(IF(D5<C5,D5+1,D5),6\/24)-MAX(C5,0))*24<\/p>\n

C\u00f4ng th\u1ee9c n\u00e0y x\u1eed l\u00fd c\u1ea3 hai \u0111o\u1ea1n ban \u0111\u00eam, \u0111o\u1ea1n t\u1eeb 22h \u0111\u1ebfn n\u1eeda \u0111\u00eam v\u00e0 \u0111o\u1ea1n t\u1eeb n\u1eeda \u0111\u00eam \u0111\u1ebfn 6h. N\u1ebfu b\u1ea3ng ch\u1ea5m c\u00f4ng c\u1ee7a b\u1ea1n c\u00f3 ca c\u1ed1 \u0111\u1ecbnh, c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 \u00edt l\u1ed7i h\u01a1n l\u00e0 l\u1eadp s\u1eb5n m\u1ed9t sheet \u0111\u1ecbnh ngh\u0129a ca ghi r\u00f5 s\u1ed1 gi\u1edd \u0111\u00eam c\u1ee7a t\u1eebng ca, r\u1ed3i tra b\u1eb1ng h\u00e0m t\u00ecm ki\u1ebfm.<\/p>\n

Gi\u1edd l\u00e0m th\u00eam, ph\u1ea7n v\u01b0\u1ee3t qu\u00e1 gi\u1edd chu\u1ea9n trong ng\u00e0y,<\/b> G5 l\u00e0 t\u1ed5ng gi\u1edd l\u00e0m, gi\u1edd chu\u1ea9n l\u00e0 8:<\/p>\n

=MAX(0,G5-8)<\/p>\n

Nh\u00f3m c\u00f4ng th\u1ee9c t\u00ednh ti\u1ec1n<\/h3>\n

\u0110\u01a1n gi\u00e1 ti\u1ec1n l\u01b0\u01a1ng gi\u1edd,<\/b> B2 l\u00e0 l\u01b0\u01a1ng th\u00e1ng, B3 l\u00e0 s\u1ed1 ng\u00e0y c\u00f4ng chu\u1ea9n, B4 l\u00e0 s\u1ed1 gi\u1edd m\u1ed7i ng\u00e0y:<\/p>\n

=B2\/(B3*B4)<\/p>\n

Ti\u1ec1n l\u00e0m th\u00eam gi\u1edd,<\/b> v\u1edbi 5 c\u1ed9t gi\u1edd l\u00e0m th\u00eam t\u1eeb P5 \u0111\u1ebfn T5 theo th\u1ee9 t\u1ef1 ng\u00e0y th\u01b0\u1eddng ban ng\u00e0y, ng\u00e0y th\u01b0\u1eddng ban \u0111\u00eam, ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n, ng\u00e0y l\u1ec5 t\u1ebft ban ng\u00e0y, ng\u00e0y l\u1ec5 t\u1ebft ban \u0111\u00eam:<\/p>\n

=$B$5*(P5*1.5+Q5*2.1+R5*2+S5*3+T5*3.9)<\/p>\n

Trong \u0111\u00f3 B5 l\u00e0 \u0111\u01a1n gi\u00e1 ti\u1ec1n l\u01b0\u01a1ng gi\u1edd. C\u00e1c h\u1ec7 s\u1ed1 l\u00e0 m\u1ee9c t\u1ed1i thi\u1ec3u theo lu\u1eadt, doanh nghi\u1ec7p tr\u1ea3 cao h\u01a1n th\u00ec s\u1eeda l\u1ea1i.<\/p>\n

Nh\u00f3m c\u00f4ng th\u1ee9c c\u1ea3nh b\u00e1o<\/h3>\n

C\u1ea3nh b\u00e1o v\u01b0\u1ee3t tr\u1ea7n 40 gi\u1edd l\u00e0m th\u00eam trong th\u00e1ng,<\/b> U5 l\u00e0 t\u1ed5ng gi\u1edd l\u00e0m th\u00eam th\u00e1ng:<\/p>\n

=IF(U5>40,”V\u01b0\u1ee3t tr\u1ea7n th\u00e1ng”,IF(U5>32,”S\u1eafp ch\u1ea1m tr\u1ea7n”,””))<\/p>\n

C\u1ea3nh b\u00e1o v\u01b0\u1ee3t tr\u1ea7n 200 gi\u1edd trong n\u0103m,<\/b> V5 l\u00e0 l\u0169y k\u1ebf gi\u1edd l\u00e0m th\u00eam t\u1eeb \u0111\u1ea7u n\u0103m:<\/p>\n

=IF(V5>200,”V\u01b0\u1ee3t tr\u1ea7n n\u0103m”,IF(V5>160,”S\u1eafp ch\u1ea1m tr\u1ea7n”,””))<\/p>\n

Ki\u1ec3m tra \u00f4 ch\u1ea5m c\u00f4ng c\u00f3 k\u00fd hi\u1ec7u l\u1ea1,<\/b> \u0111\u1eb7t Data Validation ki\u1ec3u List tr\u1ecf v\u00e0o danh m\u1ee5c k\u00fd hi\u1ec7u \u0111\u00e3 ban h\u00e0nh. C\u00e1ch n\u00e0y ch\u1eb7n l\u1ed7i g\u00f5 sai ngay t\u1eeb \u0111\u1ea7u, t\u1ed1t h\u01a1n l\u00e0 \u0111i s\u1eeda sau.<\/p>\n

T\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng c\u1ed9t ng\u00e0y ngh\u1ec9 h\u1eb1ng tu\u1ea7n,<\/b> ch\u1ecdn v\u00f9ng ch\u1ea5m c\u00f4ng r\u1ed3i d\u00f9ng Conditional Formatting ki\u1ec3u c\u00f4ng th\u1ee9c, v\u1edbi F$4 l\u00e0 \u00f4 ch\u1ee9a ng\u00e0y:<\/p>\n

=OR(WEEKDAY(F$4,2)=7,WEEKDAY(F$4,2)=6)<\/p>\n

S\u1eeda l\u1ea1i \u0111i\u1ec1u ki\u1ec7n theo ch\u1ebf \u0111\u1ed9 ngh\u1ec9 c\u1ee7a \u0111\u01a1n v\u1ecb. C\u00f3 m\u00e0u ph\u00e2n bi\u1ec7t th\u00ec ng\u01b0\u1eddi ch\u1ea5m c\u00f4ng kh\u00f4ng nh\u1ea7m gi\u1edd l\u00e0m th\u00eam ng\u00e0y th\u01b0\u1eddng v\u1edbi ng\u00e0y ngh\u1ec9, \u0111\u00e2y l\u00e0 l\u1ed7i g\u00e2y sai l\u01b0\u01a1ng ph\u1ed5 bi\u1ebfn.<\/p>\n

Khi n\u00e0o n\u00ean chuy\u1ec3n sang ch\u1ea5m c\u00f4ng t\u1ef1 \u0111\u1ed9ng<\/h2>\n

B\u1ea3ng Excel ph\u00f9 h\u1ee3p \u0111\u1ebfn m\u1ed9t quy m\u00f4 nh\u1ea5t \u0111\u1ecbnh. B\u1ed1n d\u1ea5u hi\u1ec7u c\u1ea7n chuy\u1ec3n:<\/p>\n\n\n\n\n\n\n\n
\n

D\u1ea5u hi\u1ec7u<\/p>\n<\/td>\n

\n

V\u1ea5n \u0111\u1ec1<\/p>\n<\/td>\n<\/tr>\n

\n

M\u1ea5t nhi\u1ec1u ng\u00e0y m\u1ed7i th\u00e1ng \u0111\u1ec3 t\u1ed5ng h\u1ee3p ch\u1ea5m c\u00f4ng<\/p>\n<\/td>\n

\n

Chi ph\u00ed nh\u00e2n s\u1ef1 l\u1edbn h\u01a1n chi ph\u00ed ph\u1ea7n m\u1ec1m<\/p>\n<\/td>\n<\/tr>\n

\n

Th\u01b0\u1eddng xuy\u00ean c\u00f3 khi\u1ebfu n\u1ea1i v\u1ec1 s\u1ed1 c\u00f4ng, s\u1ed1 gi\u1edd l\u00e0m th\u00eam<\/p>\n<\/td>\n

\n

D\u1eef li\u1ec7u kh\u00f4ng tin c\u1eady, kh\u00f4ng c\u00f3 ngu\u1ed3n \u0111\u1ed1i chi\u1ebfu<\/p>\n<\/td>\n<\/tr>\n

\n

Nhi\u1ec1u ca, nhi\u1ec1u \u0111\u1ecba \u0111i\u1ec3m, nhi\u1ec1u lo\u1ea1i h\u1ee3p \u0111\u1ed3ng<\/p>\n<\/td>\n

\n

S\u1ed1 quy t\u1eafc v\u01b0\u1ee3t kh\u1ea3 n\u0103ng c\u1ee7a c\u00f4ng th\u1ee9c Excel<\/p>\n<\/td>\n<\/tr>\n

\n

Kh\u00f4ng ki\u1ec3m so\u00e1t \u0111\u01b0\u1ee3c tr\u1ea7n gi\u1edd l\u00e0m th\u00eam<\/p>\n<\/td>\n

\n

R\u1ee7i ro b\u1ecb x\u1eed ph\u1ea1t<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Ch\u1ea5m c\u00f4ng v\u00e0 t\u00ednh l\u01b0\u01a1ng tr\u00ean h\u1ec7 th\u1ed1ng<\/h2>\n

Ph\u00e2n h\u1ec7 qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 c\u1ee7a Arito<\/a><\/span> x\u1eed l\u00fd ph\u1ea7n n\u00e0y:<\/span><\/p>\n