{"id":6082,"date":"2024-12-21T13:27:12","date_gmt":"2024-12-21T13:27:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/dem-so-lan-quen-cham-cong-tren-may-cham-cong\/"},"modified":"2024-12-21T13:27:12","modified_gmt":"2024-12-21T13:27:12","slug":"dem-so-lan-quen-cham-cong-tren-may-cham-cong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/dem-so-lan-quen-cham-cong-tren-may-cham-cong\/","title":{"rendered":"\u0110\u1ebfm s\u1ed1 l\u1ea7n qu\u00ean ch\u1ea5m c\u00f4ng tr\u00ean m\u00e1y ch\u1ea5m c\u00f4ng"},"content":{"rendered":"
\n

Chuy\u1ec7n k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng:<\/strong><\/p>\n

C\u00f4ng ty m\u1edbi l\u1eafp c\u00e1i m\u00e1y ch\u1ea5m c\u00f4ng. S\u1ebfp h\u00ed h\u1eedng b\u1ea3o r\u1eb1ng:<\/p>\n

\u2013 C\u00f3 m\u00e1y ch\u1ea5m c\u00f4ng r\u1ed3i th\u00ec k\u1ebf to\u00e1n b\u1ecdn em s\u01b0\u1edbng nh\u00e9, kh\u00f4ng ph\u1ea3i ch\u1ea5m c\u00f4ng b\u1eb1ng tay n\u1eefa, c\u00f3 m\u00e1y t\u1ef1\u00a0\u0111\u1ed9ng l\u00e0m h\u1ebft r\u1ed3i.<\/p>\n

Th\u1ebf nh\u01b0ng\u00a0\u0111\u1eddi kh\u00f4ng nh\u01b0 m\u01a1, ng\u01b0\u1eddi th\u00ec ch\u1ea5m c\u00f4ng\u00a0\u0111\u1ee7, ng\u01b0\u1eddi l\u1ea1i qu\u00ean kh\u00f4ng ch\u1ea5m c\u00f4ng khi ra v\u1ec1. Th\u1ebf l\u00e0 cu\u1ed1i th\u00e1ng m\u00ecnh ch\u1eb3ng th\u1ec3 n\u00e0o t\u00ednh c\u00f4ng\u00a0\u0111\u01b0\u1ee3c. S\u1ebfp th\u00ec cau c\u00f3:<\/p>\n

\u2013\u00a0\u0110\u1ebfm cho anh xem s\u1ed1 l\u1ea7n qu\u00ean ch\u1ea5m c\u00f4ng c\u1ee7a m\u1ed7i ng\u01b0\u1eddi l\u00e0 bao nhi\u00eau. M\u1ed7i l\u1ea7n qu\u00ean ch\u1ea5m c\u00f4ng th\u00ec ph\u1ea3i ph\u1ea1t m\u1edbi nh\u1edb.<\/p>\n

C\u00e1i k\u1ebft qu\u1ea3 ch\u1ea5m c\u00f4ng n\u00f3 th\u1ebf n\u00e0y:<\/p>\n

<\/p>\n

Th\u1ebf l\u00e0 th\u00eam vi\u1ec7c r\u1ed3i, m\u00ecnh ch\u1eb3ng bi\u1ebft d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u1ebfm\u00a0\u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y qu\u00ean ch\u1ea5m c\u00f4ng c\u1ea3, ch\u1ec9 bi\u1ebft ng\u1ed3i\u00a0\u0111\u1ebfm b\u1eb1ng tay th\u00f4i. V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, blog.hocexcel.online<\/a> se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n ca\u0301ch \u0111\u00ea\u0301m s\u1ed1 l\u1ea7n qu\u00ean ch\u1ea5m c\u00f4ng tr\u00ean m\u00e1y ch\u1ea5m c\u00f4ng m\u00f4\u0323t ca\u0301ch nhanh nh\u00e2\u0301t.<\/p>\n

\n
\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014<\/p>\n

HEO tr\u1ea3 l\u1eddi b\u1ea1n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> T\u1ea1o 1 b\u1ea3ng ph\u1ee5 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 b\u1ea3ng ch\u1ea5m c\u00f4ng c\u1ee7a m\u00e1y ch\u1ea5m c\u00f4ng<\/p>\n

<\/p>\n

B\u01b0\u1edbc 2:<\/strong> T\u1ea1i b\u1ea3ng ph\u1ee5, ch\u00fang ta x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 gi\u1edd ch\u00eanh l\u1ec7ch gi\u1eefa gi\u1edd v\u00e0o v\u1edbi gi\u1edd ra<\/p>\n

\n

=IF(AND(D7=\u201d\u201d,E7=\u201d\u201d),0,ROUND((E7-D7)*24,2))<\/p>\n<\/blockquote>\n

Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/p>\n

IF(AND(D7=\u201d\u201d,E7=\u201d\u201d),0, l\u00e0 N\u1ebfu th\u1eddi gian c\u1ee7a gi\u1edd v\u00e0o v\u00e0 gi\u1edd ra\u00a0\u0111\u1ec1u kh\u00f4ng c\u00f3 th\u00ec s\u1ed1 gi\u1edd c\u00f4ng b\u1eb1ng 0<\/p>\n

ROUND((E7-D7)*24,2) l\u00e0 n\u1ebfu c\u00f3\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u00ean l\u00e0 sai (t\u1ee9c l\u00e0 c\u00f3 ch\u1ea5m c\u00f4ng gi\u1edd v\u00e0o ho\u1eb7c gi\u1edd ra, ho\u1eb7c c\u1ea3 2) th\u00ec s\u1ebd l\u1ea5y th\u1eddi gian ra tr\u1eeb th\u1eddi gian v\u00e0o, k\u1ebft qu\u1ea3\u00a0\u0111\u00f3 nh\u00e2n v\u1edbi 24\u00a0\u0111\u1ec3 ra\u00a0\u0111\u01b0\u1ee3c s\u1ed1 gi\u1edd, sau\u00a0\u0111\u00f3 l\u00e0m tr\u00f2n s\u1ed1 t\u1edbi sau d\u1ea5u ph\u1ea9y 2 ch\u1eef s\u1ed1.<\/p>\n

T\u1ea1i sao l\u1ea1i nh\u00e2n v\u1edbi 24 th\u00ec m\u1eddi c\u00e1c b\u1ea1n\u00a0\u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y:\u00a0C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 gi\u1edd l\u00e0m vi\u1ec7c d\u1ef1a tr\u00ean gi\u1edd v\u00e0o, gi\u1edd ra<\/a><\/p>\n

B\u01b0\u1edbc 3:<\/strong> Copy c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3 cho c\u00e1c ng\u00e0y c\u00f2n l\u1ea1i, c\u00e1c nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i. L\u01b0u\u00a0\u00fd c\u1ea5u tr\u00fac b\u1ea3ng ph\u1ee5 v\u00e0 b\u1ea3ng ch\u00ednh ph\u1ea3i t\u01b0\u01a1ng\u00a0\u0111\u1ed3ng nhau, v\u00e0 b\u1ea3ng ch\u00ednh m\u1ed7i ng\u00e0y c\u00f3 2 c\u1ed9t, th\u00ec b\u1ea3ng ph\u1ee5 s\u1ebd tr\u1ed9n 2 c\u1ed9t v\u00e0o l\u00e0m m\u1ed9t)<\/p>\n

B\u01b0\u1edbc 4:<\/strong> V\u1edbi nh\u1eefng ng\u00e0y kh\u00f4ng ch\u1ea5m c\u00f4ng gi\u1edd ra, s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 s\u1ed1 gi\u1edd l\u00e0m <0<\/p>\n

B\u01b0\u1edbc 5<\/strong>: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0\u0111\u1ebfm s\u1ed1 ng\u00e0y c\u00f3 gi\u1edd l\u00e0m <0 t\u1ea1i c\u1ed9t c\u1ea7n t\u00ednh k\u1ebft qu\u1ea3<\/p>\n

<\/p>\n

C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/p>\n

\n

=COUNTIF(D13:BM13,\u201d<\u201c&0)<\/p>\n<\/blockquote>\n

V\u00ec b\u1ea3ng ph\u1ee5 v\u00e0 b\u1ea3ng ch\u00ednh c\u00f3 c\u1ea5u tr\u00fac t\u01b0\u01a1ng\u00a0\u0111\u1ed3ng n\u00ean c\u00f3 th\u1ec3 d\u00f9ng n\u1ed9i dung b\u1ea3ng ph\u1ee5 l\u00e0m k\u1ebft qu\u1ea3 t\u1ea1i b\u1ea3ng ch\u00ednh.<\/p>\n

B\u01b0\u1edbc 6:<\/strong> Copy c\u00f4ng th\u1ee9c cho nh\u1eefng nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i, sau\u00a0\u0111\u00f3\u00a0\u1ea9n ph\u1ea7n c\u1ed9t ph\u1ee5\u00a0\u0111i, trang tr\u00ed l\u1ea1i b\u1ea3ng cho\u00a0\u0111\u1eb9p<\/p>\n

<\/p>\n

Nh\u01b0 v\u00e2\u0323y v\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y thi\u0300 ba\u0323n co\u0301 th\u00ea\u0309\u00a0ho\u00e0n to\u00e0n t\u1ef1 tin khi x\u1eed l\u00fd d\u1eef li\u1ec7u t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o. \u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng\u00a0Excel trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1,\u00a0c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0tham gia kh\u00f3a h\u1ecdc excel online<\/a>, kho\u0301a ho\u0323c excel VBA\u2026 v\u01a1\u0301i ca\u0301c chuy\u00ean gia co\u0301 nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n va\u0300\u00a0cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh, nh\u00e2n s\u1ef1 trong th\u1ef1c t\u1ebf v\u00e0 c\u00e1c k\u1ef9 n\u0103ng\u00a0excel k\u1ebft h\u1ee3p v\u1edbi VBA\u00a0\u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c, t\u1ed1i\u00a0\u01b0u hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea1n.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6083,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6082","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6082"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6082\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6083"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}