{"id":15646,"date":"2022-05-05T09:06:56","date_gmt":"2022-05-05T02:06:56","guid":{"rendered":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/?post_type=ht_kb&#038;p=15646"},"modified":"2026-01-02T15:14:34","modified_gmt":"2026-01-02T08:14:34","slug":"dat-cong-thuc-lam-tron-cac-thanh-phan-luong-mac-dinh","status":"publish","type":"ht_kb","link":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/dat-cong-thuc-lam-tron-cac-thanh-phan-luong-mac-dinh\/","title":{"rendered":"\u0110\u1eb7t c\u00f4ng th\u1ee9c l\u00e0m tr\u00f2n c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng m\u1eb7c \u0111\u1ecbnh"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><b>M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND \u0111\u1ec3 l\u00e0m tr\u00f2n ch\u00ednh x\u00e1c c\u00e1c kho\u1ea3n l\u01b0\u01a1ng trong t\u00ednh l\u01b0\u01a1ng.<br \/>\n<b>N\u1ed9i dung:<\/b><br \/>\n&#8211; \u00c1p d\u1ee5ng h\u00e0m ROUND cho c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng m\u1eb7c \u0111\u1ecbnh<br \/>\n&#8211; K\u1ebft qu\u1ea3 l\u00e0m tr\u00f2n t\u1ef1 \u0111\u1ed9ng tr\u00ean b\u1ea3ng l\u01b0\u01a1ng v\u00e0 b\u1ea3ng thu\u1ebf<br \/>\n<b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> HR, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, qu\u1ea3n tr\u1ecb vi\u00ean h\u1ec7 th\u1ed1ng<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1:<\/strong> X\u00e1c \u0111\u1ecbnh c\u00e1c th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng c\u1ea7n l\u00e0m tr\u00f2n nh\u01b0 Thu\u1ebf TNCN, BHXH, KPC\u0110,&#8230;<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> \u0110\u1eb7t h\u00e0m <strong>ROUND<\/strong> trong c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n cho t\u1eebng th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng theo c\u00fa ph\u00e1p: ROUND(s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n, s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n).<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> L\u01b0u c\u1ea5u h\u00ecnh c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Khi b\u1ea5m <strong>L\u01b0u<\/strong>, ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb Th\u00f4ng b\u00e1o &#8221; B\u1ea1n c\u00f3 mu\u1ed1n c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb c\u1ee7a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng tr\u00ean c\u00e1c m\u1eabu b\u1ea3ng l\u01b0\u01a1ng \u0111ang \u00e1p d\u1ee5ng v\u00e0 L\u1ecbch s\u1eed l\u01b0\u01a1ng kh\u00f4ng?, Anh\\Ch\u1ecb t\u00f9y ch\u1ecdn theo nhu c\u1ea7u.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Ki\u1ec3m tra k\u1ebft qu\u1ea3 tr\u00ean c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 b\u1ea3ng l\u01b0\u01a1ng, b\u1ea3ng thu\u1ebf \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng l\u00e0m tr\u00f2n theo c\u00f4ng th\u1ee9c \u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2022\/05\/1.1.lam-tron.png\" alt=\"\" width=\"1584\" height=\"900\" \/><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><br \/>\n&#8211; N\u00ean th\u1ed1ng nh\u1ea5t s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n khi l\u00e0m tr\u00f2n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh nh\u1ea5t qu\u00e1n trong b\u00e1o c\u00e1o.<br \/>\n&#8211; H\u00e0m ROUND gi\u00fap t\u0103ng \u0111\u1ed9 ch\u00ednh x\u00e1c v\u00e0 t\u00ednh chuy\u00ean nghi\u1ec7p trong b\u00e1o c\u00e1o l\u01b0\u01a1ng.<\/p>\n<\/div><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;<\/p>\n","protected":false},"author":107,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[195],"ht-kb-tag":[],"class_list":["post-15646","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-rc20-phat-hanh-ngay-06-05-2022"],"_links":{"self":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/15646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=15646"}],"version-history":[{"count":3,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/15646\/revisions"}],"predecessor-version":[{"id":18373,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/15646\/revisions\/18373"}],"wp:attachment":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=15646"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=15646"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=15646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}