{"id":10441,"date":"2025-01-14T07:54:14","date_gmt":"2025-01-14T07:54:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-ung-dung-ham-int-va-mod-trong-cong-viec\/"},"modified":"2025-01-14T07:54:14","modified_gmt":"2025-01-14T07:54:14","slug":"huong-dan-cach-ung-dung-ham-int-va-mod-trong-cong-viec","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-ung-dung-ham-int-va-mod-trong-cong-viec\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m INT v\u00e0 MOD trong c\u00f4ng vi\u1ec7c"},"content":{"rendered":"
\n

Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft h\u00e0m INT<\/a> v\u00e0 MOD l\u00e0 hai h\u00e0m li\u00ean quan t\u1edbi ph\u00e9p chia trong Excel. INT x\u00e1c \u0111\u1ecbnh ph\u1ea7n nguy\u00ean c\u1ee7a ph\u00e9p chia, c\u00f2n MOD x\u00e1c \u0111\u1ecbnh ph\u1ea7n s\u1ed1 d\u01b0. Nh\u01b0ng\u00a0b\u1ea1n c\u00f3 bi\u1ebft hai h\u00e0m n\u00e0y \u00e1p d\u1ee5ng trong th\u1ef1c t\u1ebf th\u1ebf n\u00e0o kh\u00f4ng? H\u00e3y c\u00f9ng H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u\u00a0c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m INT v\u00e0 MOD trong c\u00f4ng vi\u1ec7c:<\/p>\n

X\u00e1c \u0111\u1ecbnh th\u1eddi gian l\u01b0u tr\u00fa t\u1ea1i kh\u00e1ch s\u1ea1n, nh\u00e0 ngh\u1ec9<\/h3>\n

Nghi\u1ec7p v\u1ee5 c\u01a1 b\u1ea3n c\u1ee7a l\u1ec5 t\u00e2n kh\u00e1ch s\u1ea1n, nh\u00e0 ngh\u1ec9 l\u00e0 x\u00e1c \u0111\u1ecbnh th\u1eddi gian l\u01b0u tr\u00fa c\u1ee7a kh\u00e1ch. Th\u1eddi gian l\u01b0u tr\u00fa t\u00ednh t\u1eeb khi kh\u00e1ch h\u00e0ng nh\u1eadn ph\u00f2ng (check-in) cho t\u1edbi khi tr\u1ea3 ph\u00f2ng (check-out). V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh kho\u1ea3ng th\u1eddi gian l\u01b0u tr\u00fa gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m check-in v\u00e0 check-out n\u00e0y?<\/p>\n

V\u00ed d\u1ee5: X\u00e1c \u0111\u1ecbnh kho\u1ea3ng th\u1eddi gian l\u01b0u tr\u00fa l\u00e0 bao nhi\u00eau tu\u1ea7n, l\u1ebb bao nhi\u00eau ng\u00e0y trong b\u1ea3ng sau:<\/p>\n

<\/p>\n

Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INT v\u00e0 MOD nh\u01b0 sau:<\/p>\n

\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 tu\u1ea7n:<\/strong><\/p>\n

Xem th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INT<\/a><\/p>\n

Nguy\u00ean t\u1eafc l\u00e0 1 tu\u1ea7n c\u00f3 7 ng\u00e0y. Do \u0111\u00f3 s\u1ed1 tu\u1ea7n \u0111\u01b0\u1ee3c t\u00ednh\u00a0=(S\u1ed1 ng\u00e0y gi\u1eefa kho\u1ea3ng th\u1eddi gian Check-out tr\u1eeb \u0111i th\u1eddi gian Check-in)\/7 v\u00e0 ch\u1ec9 l\u1ea5y ph\u1ea7n nguy\u00ean (t\u1ee9c l\u00e0 \u0111\u1ee7 7 ng\u00e0y)<\/p>\n

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

C2=INT((B2-A2)\/7)<\/p>\n

\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c \u1edf C2 xu\u1ed1ng c\u00e1c \u00f4 C3, C4 c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n

<\/p>\n

\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y l\u1ebb<\/strong><\/p>\n

Xem th\u00eam: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD<\/p>\n

S\u1ed1 ng\u00e0y l\u1ebb l\u00e0 s\u1ed1 ng\u00e0y trong kho\u1ea3ng th\u1eddi gian tr\u00ean m\u00e0 kh\u00f4ng \u0111\u1ee7 7 ng\u00e0y. \u0110i\u1ec1u n\u00e0y \u0111\u1ed3ng ngh\u0129a v\u1edbi \u0111\u00e2y l\u00e0 ph\u1ea7n d\u01b0 c\u1ee7a ph\u00e9p t\u00ednh<\/p>\n

(S\u1ed1 ng\u00e0y gi\u1eefa kho\u1ea3ng th\u1eddi gian Check-out tr\u1eeb \u0111i th\u1eddi gian Check-in)\/7<\/p>\n

Do \u0111\u00f3 khi d\u00f9ng h\u00e0m MOD th\u00ec ch\u00fang ta s\u1ebd vi\u1ebft nh\u01b0 sau:<\/p>\n

D2=MOD(B2-A2,7)<\/p>\n

\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c \u1edf D2 xu\u1ed1ng c\u00e1c \u00f4 D3, D4 c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n

<\/p>\n

Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 h\u00ecnh dung \u0111\u01b0\u1ee3c vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m MOD v\u00e0 INT v\u00e0o c\u00f4ng vi\u1ec7c th\u1ef1c t\u1ebf r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o? B\u1ea1n c\u00f3 g\u1eb7p y\u00eau c\u1ea7u n\u00e0o v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m INT v\u00e0 MOD kh\u00e1c kh\u00f4ng, h\u00e3y chia s\u1ebb c\u00f9ng H\u1ecdc Excel Online nh\u00e9.<\/p>\n

Tham kh\u1ea3o:<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Int<\/a> chi ti\u1ebft, \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c<\/strong><\/p>\n

Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10442,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10441","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10441","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=10441"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10441\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10442"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}