{"id":12446,"date":"2026-06-17T22:28:48","date_gmt":"2026-06-17T15:28:48","guid":{"rendered":"https:\/\/arito.vn\/?p=12446"},"modified":"2026-07-12T13:44:10","modified_gmt":"2026-07-12T06:44:10","slug":"bang-cham-cong-excel-theo-gio-pho-bien-nhat-hien-nay","status":"publish","type":"post","link":"https:\/\/arito.vn\/en\/bang-cham-cong-excel-theo-gio-pho-bien-nhat-hien-nay\/","title":{"rendered":"B\u1ea3ng Ch\u1ea5m C\u00f4ng Theo Gi\u1edd Excel: M\u1eabu T\u1ea3i Mi\u1ec5n Ph\u00ed, C\u00f4ng Th\u1ee9c T\u00ednh V\u00e0 C\u00e1ch L\u1eadp"},"content":{"rendered":"<p class=\"p1\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd l\u00e0 c\u00f4ng c\u1ee5 ghi l\u1ea1i gi\u1edd v\u00e0o, gi\u1edd ra th\u1ef1c t\u1ebf c\u1ee7a nh\u00e2n vi\u00ean \u0111\u1ec3 t\u00ednh ch\u00ednh x\u00e1c s\u1ed1 gi\u1edd c\u00f4ng, gi\u1edd t\u0103ng ca v\u00e0 th\u1eddi gian \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm. B\u00e0i vi\u1ebft cung c\u1ea5p <b>b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd Excel<\/b> t\u1ea3i mi\u1ec5n ph\u00ed, k\u00e8m c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 gi\u1edd c\u00f4ng (k\u1ec3 c\u1ea3 ca qua \u0111\u00eam), c\u00e1ch t\u00ednh gi\u1edd t\u0103ng ca theo lu\u1eadt, c\u00e1c h\u00e0m Excel c\u1ea7n d\u00f9ng v\u00e0 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p. B\u1ea1n t\u1ea3i file v\u1ec1, \u0111i\u1ec1n gi\u1edd v\u00e0o gi\u1edd ra l\u00e0 b\u1ea3ng t\u1ef1 t\u00ednh t\u1ed5ng gi\u1edd.<\/p>\n<h2 class=\"p2\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd l\u00e0 g\u00ec?<\/h2>\n<p class=\"p1\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd l\u00e0 bi\u1ec3u m\u1eabu ghi nh\u1eadn th\u1eddi gian l\u00e0m vi\u1ec7c th\u1ef1c t\u1ebf c\u1ee7a t\u1eebng nh\u00e2n vi\u00ean theo gi\u1edd v\u00e0o v\u00e0 gi\u1edd ra trong ng\u00e0y. Kh\u00e1c v\u1edbi b\u1ea3ng ch\u1ea5m c\u00f4ng theo ng\u00e0y (ch\u1ec9 \u0111\u00e1nh d\u1ea5u c\u00f3 \u0111i l\u00e0m hay kh\u00f4ng), b\u1ea3ng theo gi\u1edd cho bi\u1ebft ch\u00ednh x\u00e1c m\u1ed9t ng\u01b0\u1eddi l\u00e0m bao nhi\u00eau gi\u1edd, t\u0103ng ca bao nhi\u00eau, \u0111i tr\u1ec5 hay v\u1ec1 s\u1edbm bao l\u00e2u.<\/p>\n<p class=\"p1\">C\u00e1ch ch\u1ea5m c\u00f4ng n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi doanh nghi\u1ec7p tr\u1ea3 l\u01b0\u01a1ng theo gi\u1edd, l\u00e0m vi\u1ec7c theo ca, ho\u1eb7c c\u00f3 nhi\u1ec1u t\u0103ng ca nh\u01b0 nh\u00e0 h\u00e0ng, s\u1ea3n xu\u1ea5t, b\u00e1n l\u1ebb v\u00e0 d\u1ecbch v\u1ee5.<\/p>\n<h2 class=\"p3\">L\u1ee3i \u00edch c\u1ee7a b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd b\u1eb1ng Excel<\/h2>\n<ul class=\"ul1\">\n<li class=\"li4\"><b>T\u00ednh l\u01b0\u01a1ng ch\u00ednh x\u00e1c<\/b>: tr\u1ea3 \u0111\u00fang theo s\u1ed1 gi\u1edd l\u00e0m th\u1ef1c t\u1ebf, minh b\u1ea1ch v\u1edbi nh\u00e2n vi\u00ean.<\/li>\n<li class=\"li4\"><b>Ki\u1ec3m so\u00e1t t\u0103ng ca<\/b>: bi\u1ebft r\u00f5 ai t\u0103ng ca bao nhi\u00eau \u0111\u1ec3 t\u00ednh \u0111\u00fang h\u1ec7 s\u1ed1 v\u00e0 ki\u1ec3m so\u00e1t chi ph\u00ed.<\/li>\n<li class=\"li4\"><b>Mi\u1ec5n ph\u00ed, d\u1ec5 d\u00f9ng<\/b>: ch\u1ec9 c\u1ea7n Excel, kh\u00f4ng t\u1ed1n chi ph\u00ed ph\u1ea7n m\u1ec1m ban \u0111\u1ea7u.<\/li>\n<li class=\"li4\"><b>Linh ho\u1ea1t<\/b>: t\u00f9y ch\u1ec9nh c\u1ed9t, th\u00eam ca, th\u00eam c\u00f4ng th\u1ee9c theo nhu c\u1ea7u.<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-12453\" src=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-21-at-22.36.42.png\" alt=\"L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng b\u1ea3ng ch\u1ea5m c\u00f4ng Excel theo gi\u1edd \" width=\"1456\" height=\"844\" srcset=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-21-at-22.36.42.png 1456w, https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-21-at-22.36.42-18x10.png 18w\" sizes=\"(max-width: 1456px) 100vw, 1456px\" \/><\/p>\n<h2 class=\"p1\">N\u1ed9i dung c\u1ea7n c\u00f3 trong b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd<\/h2>\n<p class=\"p2\">M\u1ed9t b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd \u0111\u1ea7y \u0111\u1ee7 n\u00ean g\u1ed3m:<\/p>\n<table class=\"t1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">Nh\u00f3m<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">C\u1ed9t c\u1ea7n c\u00f3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">Th\u00f4ng tin nh\u00e2n vi\u00ean<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">M\u00e3 nh\u00e2n vi\u00ean, h\u1ecd t\u00ean, b\u1ed9 ph\u1eadn<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">Th\u1eddi gian l\u00e0m vi\u1ec7c<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">Ng\u00e0y c\u00f4ng, gi\u1edd v\u00e0o, gi\u1edd ra, gi\u1edd ngh\u1ec9 tr\u01b0a<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">K\u1ebft qu\u1ea3 t\u00ednh<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">T\u1ed5ng gi\u1edd c\u00f4ng, s\u1ed1 gi\u1edd l\u00e0m th\u00eam (OT), \u0111i mu\u1ed9n\/v\u1ec1 s\u1edbm<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">X\u00e1c nh\u1eadn<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">Ghi ch\u00fa, k\u00fd x\u00e1c nh\u1eadn c\u1ee7a nh\u00e2n vi\u00ean v\u00e0 qu\u1ea3n l\u00fd<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 class=\"p1\">C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 gi\u1edd c\u00f4ng trong Excel<\/h2>\n<p class=\"p2\">\u0110\u00e2y l\u00e0 ph\u1ea7n quan tr\u1ecdng v\u00e0 c\u0169ng d\u1ec5 sai nh\u1ea5t.<\/p>\n<p class=\"p2\"><b>C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n:<\/b><b><\/b><\/p>\n<p class=\"p4\">S\u1ed1 gi\u1edd c\u00f4ng = Gi\u1edd ra \u2212 Gi\u1edd v\u00e0o \u2212 Th\u1eddi gian ngh\u1ec9<\/p>\n<p class=\"p2\">Trong Excel, n\u1ebfu \u00f4 gi\u1edd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian, b\u1ea1n l\u1ea5y <span class=\"s1\">= Gi\u1edd ra \u2212 Gi\u1edd v\u00e0o<\/span>. K\u1ebft qu\u1ea3 ra d\u1ea1ng gi\u1edd:ph\u00fat. \u0110\u1ec3 \u0111\u1ed5i sang s\u1ed1 gi\u1edd th\u1eadp ph\u00e2n (d\u1ec5 nh\u00e2n v\u1edbi \u0111\u01a1n gi\u00e1), nh\u00e2n th\u00eam 24: <span class=\"s1\">=(Gi\u1edd ra \u2212 Gi\u1edd v\u00e0o)*24<\/span>.<\/p>\n<p class=\"p2\"><b>X\u1eed l\u00fd ca l\u00e0m qua \u0111\u00eam:<\/b><b><\/b><\/p>\n<p class=\"p2\">N\u1ebfu nh\u00e2n vi\u00ean v\u00e0o l\u00fac 22h v\u00e0 ra l\u00fac 6h s\u00e1ng h\u00f4m sau, ph\u00e9p tr\u1eeb th\u00f4ng th\u01b0\u1eddng ra s\u1ed1 \u00e2m. D\u00f9ng h\u00e0m MOD \u0111\u1ec3 x\u1eed l\u00fd:<\/p>\n<p class=\"p5\">=MOD(Gi\u1edd ra \u2212 Gi\u1edd v\u00e0o, 1)*24<\/p>\n<p class=\"p2\">H\u00e0m MOD t\u1ef1 c\u1ed9ng th\u00eam m\u1ed9t ng\u00e0y khi gi\u1edd ra nh\u1ecf h\u01a1n gi\u1edd v\u00e0o, n\u00ean ca qua \u0111\u00eam v\u1eabn t\u00ednh \u0111\u00fang.<\/p>\n<p class=\"p2\"><b>\u0110\u1ecbnh d\u1ea1ng \u00f4 hi\u1ec3n th\u1ecb tr\u00ean 24 gi\u1edd:<\/b><b><\/b><\/p>\n<p class=\"p2\">Khi c\u1ed9ng t\u1ed5ng gi\u1edd c\u1ea3 th\u00e1ng, n\u1ebfu v\u01b0\u1ee3t 24 gi\u1edd m\u00e0 \u00f4 \u0111\u1ecbnh d\u1ea1ng th\u01b0\u1eddng s\u1ebd hi\u1ec3n th\u1ecb sai. \u0110\u1ecbnh d\u1ea1ng \u00f4 theo <span class=\"s1\">[h]:mm<\/span> \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang t\u1ed5ng s\u1ed1 gi\u1edd l\u1edbn h\u01a1n 24.<\/p>\n<h2 class=\"p1\">C\u00e1ch t\u00ednh gi\u1edd t\u0103ng ca (OT) theo quy \u0111\u1ecbnh<\/h2>\n<p class=\"p2\">S\u1ed1 gi\u1edd t\u0103ng ca l\u00e0 ph\u1ea7n v\u01b0\u1ee3t qu\u00e1 gi\u1edd c\u00f4ng ti\u00eau chu\u1ea9n (th\u01b0\u1eddng 8 gi\u1edd\/ng\u00e0y). Theo B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019, ti\u1ec1n l\u01b0\u01a1ng l\u00e0m th\u00eam gi\u1edd \u0111\u01b0\u1ee3c t\u00ednh theo h\u1ec7 s\u1ed1:<\/p>\n<table class=\"t1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">Th\u1eddi \u0111i\u1ec3m l\u00e0m th\u00eam<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">H\u1ec7 s\u1ed1 l\u01b0\u01a1ng l\u00e0m th\u00eam<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">Ng\u00e0y th\u01b0\u1eddng<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">\u00cdt nh\u1ea5t 150%<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">Ng\u00e0y ngh\u1ec9 h\u00e0ng tu\u1ea7n<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">\u00cdt nh\u1ea5t 200%<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">Ng\u00e0y l\u1ec5, T\u1ebft, ng\u00e0y ngh\u1ec9 c\u00f3 h\u01b0\u1edfng l\u01b0\u01a1ng<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">\u00cdt nh\u1ea5t 300%<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">L\u00e0m th\u00eam v\u00e0o ban \u0111\u00eam<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">C\u1ed9ng th\u00eam \u00edt nh\u1ea5t 30%<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"p2\">Trong Excel, t\u00e1ch c\u1ed9t gi\u1edd t\u0103ng ca ri\u00eang v\u00e0 nh\u00e2n v\u1edbi h\u1ec7 s\u1ed1 t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 t\u00ednh \u0111\u00fang l\u01b0\u01a1ng l\u00e0m th\u00eam. V\u00ed d\u1ee5, gi\u1edd OT ng\u00e0y th\u01b0\u1eddng: <span class=\"s1\">= S\u1ed1 gi\u1edd OT \u00d7 \u0110\u01a1n gi\u00e1 gi\u1edd \u00d7 150%<\/span>.<\/p>\n<h2 class=\"p4\">5 h\u00e0m Excel c\u1ea7n d\u00f9ng cho b\u1ea3ng ch\u1ea5m c\u00f4ng<\/h2>\n<ul class=\"ul1\">\n<li class=\"li3\"><b>Ph\u00e9p tr\u1eeb gi\u1edd v\u00e0 MOD<\/b>: t\u00ednh s\u1ed1 gi\u1edd c\u00f4ng, x\u1eed l\u00fd ca qua \u0111\u00eam.<\/li>\n<li class=\"li3\"><b>SUM<\/b>: c\u1ed9ng t\u1ed5ng gi\u1edd c\u00f4ng v\u00e0 t\u1ed5ng OT trong th\u00e1ng, v\u00ed d\u1ee5 <span class=\"s1\">=SUM(D2:D32)<\/span>.<\/li>\n<li class=\"li5\"><span class=\"s2\"><b>IF<\/b>: g\u1eafn \u0111i\u1ec1u ki\u1ec7n, v\u00ed d\u1ee5 <\/span>=IF(TongGio&gt;=8;&#8221;\u0110\u1ee7 c\u00f4ng&#8221;;&#8221;Thi\u1ebfu c\u00f4ng&#8221;)<span class=\"s2\">.<\/span><\/li>\n<li class=\"li3\"><b>ROUND<\/b>: l\u00e0m tr\u00f2n s\u1ed1 gi\u1edd \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng g\u1ecdn, v\u00ed d\u1ee5 <span class=\"s1\">=ROUND(SoGio;1)<\/span>.<\/li>\n<li class=\"li3\"><b>VLOOKUP<\/b>: tra \u0111\u01a1n gi\u00e1 gi\u1edd ho\u1eb7c th\u00f4ng tin nh\u00e2n vi\u00ean t\u1eeb b\u1ea3ng kh\u00e1c.<\/li>\n<\/ul>\n<h2 class=\"p1\">M\u1eabu b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd Excel (t\u1ea3i mi\u1ec5n ph\u00ed)<\/h2>\n<p class=\"p2\">B\u1ea5m \u0111\u1ec3 t\u1ea3i v\u1ec1, m\u1edf b\u1eb1ng Excel v\u00e0 \u0111i\u1ec1n gi\u1edd v\u00e0o, gi\u1edd ra. File \u0111\u00e3 c\u00e0i s\u1eb5n c\u00f4ng th\u1ee9c t\u1ef1 t\u00ednh t\u1ed5ng gi\u1edd c\u00f4ng v\u00e0 gi\u1edd t\u0103ng ca.<\/p>\n<table class=\"t1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">Bi\u1ec3u m\u1eabu<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">T\u1ea3i v\u1ec1<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p3\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd (t\u1ef1 t\u00ednh gi\u1edd c\u00f4ng, OT, ca qua \u0111\u00eam)<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p4\"><a href=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Mau_Bang_Cham_Cong_Theo_Gio.xlsx\">T\u1ea3i file Excel<\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo ca<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p4\"><a href=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Mau_Bang_Cham_Cong_Theo_Ca.xlsx\">T\u1ea3i file Excel<\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p3\">B\u1ea3ng t\u1ed5ng h\u1ee3p c\u00f4ng th\u00e1ng<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p4\"><a href=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Mau_Bang_Tong_Hop_Cong_Thang.xlsx\">T\u1ea3i file Excel<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"p5\">\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-12450\" src=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-21-at-22.31.10.png\" alt=\"b\u1ea3ng ch\u1ea5m c\u00f4ng excel theo gi\u1edd\" width=\"1436\" height=\"732\" srcset=\"https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-21-at-22.31.10.png 1436w, https:\/\/arito.vn\/wp-content\/uploads\/2024\/06\/Screenshot-2024-06-21-at-22.31.10-18x9.png 18w\" sizes=\"(max-width: 1436px) 100vw, 1436px\" \/><\/p>\n<h2 class=\"p1\">Nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi l\u00e0m b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd Excel<\/h2>\n<ul class=\"ul1\">\n<li class=\"li2\"><b>S\u1ed1 gi\u1edd \u00e2m v\u1edbi ca qua \u0111\u00eam<\/b>: qu\u00ean d\u00f9ng MOD n\u00ean gi\u1edd ra nh\u1ecf h\u01a1n gi\u1edd v\u00e0o ra s\u1ed1 \u00e2m.<\/li>\n<li class=\"li2\"><b>T\u1ed5ng gi\u1edd hi\u1ec3n th\u1ecb sai khi v\u01b0\u1ee3t 24<\/b>: ch\u01b0a \u0111\u1ecbnh d\u1ea1ng \u00f4 theo <span class=\"s1\">[h]:mm<\/span>.<\/li>\n<li class=\"li2\"><b>Qu\u00ean tr\u1eeb gi\u1edd ngh\u1ec9 tr\u01b0a<\/b>: t\u00ednh d\u01b0 gi\u1edd c\u00f4ng so v\u1edbi th\u1ef1c t\u1ebf.<\/li>\n<li class=\"li2\"><b>Nh\u1eadp gi\u1edd sai \u0111\u1ecbnh d\u1ea1ng<\/b>: g\u00f5 \u201c8h\u201d thay v\u00ec \u201c08:00\u201d khi\u1ebfn c\u00f4ng th\u1ee9c kh\u00f4ng t\u00ednh \u0111\u01b0\u1ee3c.<\/li>\n<li class=\"li3\"><b>Sai c\u00f4ng th\u1ee9c khi copy<\/b>: qu\u00ean c\u1ed1 \u0111\u1ecbnh \u00f4 tham chi\u1ebfu (d\u1ea5u $) l\u00e0m l\u1ec7ch k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n<h2 class=\"p4\">C\u00f3 n\u00ean chuy\u1ec3n t\u1eeb Excel sang ph\u1ea7n m\u1ec1m ch\u1ea5m c\u00f4ng kh\u00f4ng?<\/h2>\n<table class=\"t1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Ti\u00eau ch\u00ed<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">B\u1ea3ng ch\u1ea5m c\u00f4ng Excel<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Ph\u1ea7n m\u1ec1m ch\u1ea5m c\u00f4ng, HRM<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p2\">Chi ph\u00ed ban \u0111\u1ea7u<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p2\">Mi\u1ec5n ph\u00ed<\/p>\n<\/td>\n<td class=\"td2\" valign=\"top\">\n<p class=\"p2\">C\u00f3 ph\u00ed<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Nh\u1eadp li\u1ec7u<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Th\u1ee7 c\u00f4ng, d\u1ec5 sai<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">T\u1ef1 \u0111\u1ed9ng t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng, v\u00e2n tay, app<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Ca qua \u0111\u00eam, t\u0103ng ca<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">T\u1ef1 \u0111\u1eb7t c\u00f4ng th\u1ee9c<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">T\u00ednh t\u1ef1 \u0111\u1ed9ng theo quy t\u1eafc<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Li\u00ean th\u00f4ng t\u00ednh l\u01b0\u01a1ng<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Ph\u1ea3i l\u00e0m th\u1ee7 c\u00f4ng<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">T\u1ef1 \u0111\u1ed9ng sang b\u1ea3ng l\u01b0\u01a1ng<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Ph\u00f9 h\u1ee3p<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">\u00cdt nh\u00e2n s\u1ef1, \u00edt ca<\/p>\n<\/td>\n<td class=\"td1\" valign=\"top\">\n<p class=\"p2\">Nhi\u1ec1u nh\u00e2n s\u1ef1, nhi\u1ec1u ca, nhi\u1ec1u chi nh\u00e1nh<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"p5\">Excel ph\u00f9 h\u1ee3p khi quy m\u00f4 nh\u1ecf. Khi s\u1ed1 nh\u00e2n s\u1ef1 v\u00e0 ca k\u00edp t\u0103ng, nh\u1eadp tay d\u1ec5 sai v\u00e0 t\u1ed1n th\u1eddi gian \u0111\u1ed1i chi\u1ebfu, \u0111\u00f3 l\u00e0 l\u00fac n\u00ean d\u00f9ng ph\u1ea7n m\u1ec1m.<\/p>\n<h2 class=\"p6\">Qu\u1ea3n l\u00fd ch\u1ea5m c\u00f4ng v\u00e0 t\u00ednh l\u01b0\u01a1ng t\u1ef1 \u0111\u1ed9ng v\u1edbi ph\u1ea7n m\u1ec1m Arito<\/h2>\n<p class=\"p5\">Ph\u00e2n h\u1ec7 <a href=\"https:\/\/arito.vn\/quan-ly-nhan-su-hrm\/\"><span class=\"s2\">qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 HRM<\/span><\/a> c\u1ee7a Arito gi\u00fap doanh nghi\u1ec7p:<\/p>\n<ul class=\"ul1\">\n<li class=\"li2\">Ghi nh\u1eadn c\u00f4ng theo gi\u1edd, theo ca t\u1ef1 \u0111\u1ed9ng t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng ho\u1eb7c \u1ee9ng d\u1ee5ng, x\u1eed l\u00fd ca qua \u0111\u00eam v\u00e0 t\u0103ng ca theo quy t\u1eafc c\u00e0i s\u1eb5n.<\/li>\n<li class=\"li2\">T\u00ednh gi\u1edd t\u0103ng ca theo \u0111\u00fang h\u1ec7 s\u1ed1 150%, 200%, 300% m\u00e0 kh\u00f4ng ph\u1ea3i \u0111\u1eb7t c\u00f4ng th\u1ee9c th\u1ee7 c\u00f4ng.<\/li>\n<li class=\"li5\">Li\u00ean th\u00f4ng th\u1eb3ng sang t\u00ednh l\u01b0\u01a1ng v\u00e0 <a href=\"https:\/\/arito.vn\/quan-ly-tai-chinh-ke-toan\/\"><span class=\"s2\">k\u1ebf to\u00e1n<\/span><\/a>, gi\u1ea3m sai s\u00f3t khi chuy\u1ec3n s\u1ed1 li\u1ec7u.<\/li>\n<\/ul>\n<p class=\"p5\">T\u1ea5t c\u1ea3 n\u1eb1m trong n\u1ec1n t\u1ea3ng <a href=\"https:\/\/arito.vn\/phan-mem-quan-ly-doanh-nghiep-arito\/\"><span class=\"s2\">ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd doanh nghi\u1ec7p Arito ERP<\/span><\/a>, gi\u00fap ch\u1ea5m c\u00f4ng, nh\u00e2n s\u1ef1 v\u00e0 ti\u1ec1n l\u01b0\u01a1ng d\u00f9ng chung m\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u.<\/p>\n<p class=\"p7\">Mu\u1ed1n xem ch\u1ea5m c\u00f4ng theo gi\u1edd \u0111\u01b0\u1ee3c t\u00ednh t\u1ef1 \u0111\u1ed9ng v\u00e0 chuy\u1ec3n th\u1eb3ng v\u00e0o b\u1ea3ng l\u01b0\u01a1ng ra sao? <a href=\"https:\/\/arito.vn\/yeu-cau-demo\/\"><span class=\"s2\">\u0110\u0103ng k\u00fd nh\u1eadn demo mi\u1ec5n ph\u00ed<\/span><\/a> \u0111\u1ec3 \u0111\u1ed9i ng\u0169 Arito t\u01b0 v\u1ea5n theo quy m\u00f4 nh\u00e2n s\u1ef1 c\u1ee7a b\u1ea1n.<\/p>\n<h2 class=\"p6\">C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p (FAQ)<\/h2>\n<h3 class=\"p5\"><b>C\u00e1ch t\u00ednh s\u1ed1 gi\u1edd c\u00f4ng trong Excel nh\u01b0 th\u1ebf n\u00e0o?<\/b><b><\/b><\/h3>\n<p class=\"p5\">L\u1ea5y gi\u1edd ra tr\u1eeb gi\u1edd v\u00e0o r\u1ed3i tr\u1eeb th\u1eddi gian ngh\u1ec9. Nh\u00e2n th\u00eam 24 \u0111\u1ec3 ra s\u1ed1 gi\u1edd th\u1eadp ph\u00e2n. V\u1edbi ca qua \u0111\u00eam, d\u00f9ng <span class=\"s1\">=MOD(Gi\u1edd ra \u2212 Gi\u1edd v\u00e0o; 1)*24<\/span> \u0111\u1ec3 tr\u00e1nh ra s\u1ed1 \u00e2m.<\/p>\n<h3 class=\"p5\"><b>L\u00e0m sao \u0111\u1ec3 Excel kh\u00f4ng hi\u1ec7n s\u1ed1 gi\u1edd \u00e2m khi l\u00e0m ca \u0111\u00eam?<\/b><b><\/b><\/h3>\n<p class=\"p5\">D\u00f9ng h\u00e0m MOD thay cho ph\u00e9p tr\u1eeb tr\u1ef1c ti\u1ebfp. H\u00e0m MOD t\u1ef1 c\u1ed9ng th\u00eam m\u1ed9t ng\u00e0y khi gi\u1edd ra nh\u1ecf h\u01a1n gi\u1edd v\u00e0o, n\u00ean ca qua \u0111\u00eam \u0111\u01b0\u1ee3c t\u00ednh \u0111\u00fang.<\/p>\n<h3 class=\"p5\"><b>T\u1ea1i sao t\u1ed5ng gi\u1edd trong th\u00e1ng hi\u1ec3n th\u1ecb sai?<\/b><b><\/b><\/h3>\n<p class=\"p5\">V\u00ec \u00f4 \u0111ang \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian th\u00f4ng th\u01b0\u1eddng, khi t\u1ed5ng v\u01b0\u1ee3t 24 gi\u1edd s\u1ebd hi\u1ec3n th\u1ecb sai. \u0110\u1ecbnh d\u1ea1ng \u00f4 theo <span class=\"s1\">[h]:mm<\/span> \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang t\u1ed5ng s\u1ed1 gi\u1edd l\u1edbn h\u01a1n 24.<\/p>\n<h3 class=\"p5\"><b>Gi\u1edd t\u0103ng ca \u0111\u01b0\u1ee3c t\u00ednh h\u1ec7 s\u1ed1 bao nhi\u00eau?<\/b><b><\/b><\/h3>\n<p class=\"p5\">Theo B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 2019: ng\u00e0y th\u01b0\u1eddng \u00edt nh\u1ea5t 150%, ng\u00e0y ngh\u1ec9 h\u00e0ng tu\u1ea7n \u00edt nh\u1ea5t 200%, ng\u00e0y l\u1ec5 T\u1ebft \u00edt nh\u1ea5t 300%. L\u00e0m th\u00eam ban \u0111\u00eam \u0111\u01b0\u1ee3c c\u1ed9ng th\u00eam \u00edt nh\u1ea5t 30%.<\/p>\n<h3 class=\"p5\"><b>Khi n\u00e0o n\u00ean d\u00f9ng ph\u1ea7n m\u1ec1m thay cho b\u1ea3ng ch\u1ea5m c\u00f4ng Excel?<\/b><b><\/b><\/h3>\n<p class=\"p5\">Khi s\u1ed1 nh\u00e2n s\u1ef1 v\u00e0 ca k\u00edp nhi\u1ec1u, ho\u1eb7c c\u1ea7n li\u00ean th\u00f4ng th\u1eb3ng sang t\u00ednh l\u01b0\u01a1ng. L\u00fac \u0111\u00f3 ph\u1ea7n m\u1ec1m gi\u00fap l\u1ea5y d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng, t\u00ednh t\u0103ng ca theo quy t\u1eafc v\u00e0 gi\u1ea3m sai s\u00f3t so v\u1edbi nh\u1eadp tay.<\/p>\n<p class=\"p6\">K\u1ebft lu\u1eadn<\/p>\n<p class=\"p5\">B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 ghi nh\u1eadn th\u1eddi gian l\u00e0m vi\u1ec7c v\u00e0 t\u00ednh l\u01b0\u01a1ng ch\u00ednh x\u00e1c cho doanh nghi\u1ec7p quy m\u00f4 nh\u1ecf. N\u1eafm v\u1eefng c\u00f4ng th\u1ee9c t\u00ednh gi\u1edd, c\u00e1ch x\u1eed l\u00fd ca qua \u0111\u00eam v\u00e0 h\u1ec7 s\u1ed1 t\u0103ng ca s\u1ebd gi\u00fap b\u1ea3ng ch\u1ea5m c\u00f4ng c\u1ee7a b\u1ea1n ch\u1ea1y \u0111\u00fang. Khi nh\u00e2n s\u1ef1 t\u0103ng l\u00ean, chuy\u1ec3n sang ph\u1ea7n m\u1ec1m ch\u1ea5m c\u00f4ng s\u1ebd gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 gi\u1ea3m sai s\u00f3t khi chuy\u1ec3n s\u1ed1 li\u1ec7u sang b\u1ea3ng l\u01b0\u01a1ng.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd l\u00e0 c\u00f4ng c\u1ee5 ghi l\u1ea1i gi\u1edd v\u00e0o, gi\u1edd ra th\u1ef1c t\u1ebf c\u1ee7a nh\u00e2n vi\u00ean \u0111\u1ec3 t\u00ednh ch\u00ednh x\u00e1c s\u1ed1 gi\u1edd c\u00f4ng, gi\u1edd t\u0103ng ca v\u00e0 th\u1eddi gian \u0111i mu\u1ed9n, v\u1ec1 s\u1edbm. B\u00e0i vi\u1ebft cung c\u1ea5p b\u1ea3ng ch\u1ea5m c\u00f4ng theo gi\u1edd Excel t\u1ea3i mi\u1ec5n ph\u00ed, k\u00e8m c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 gi\u1edd [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":12453,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,308],"tags":[],"class_list":["post-12446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-trong-nganh","category-quan-tri-nguon-nhan-luc"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts\/12446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/comments?post=12446"}],"version-history":[{"count":4,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts\/12446\/revisions"}],"predecessor-version":[{"id":17523,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/posts\/12446\/revisions\/17523"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/media\/12453"}],"wp:attachment":[{"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/media?parent=12446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/categories?post=12446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arito.vn\/en\/wp-json\/wp\/v2\/tags?post=12446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}