{"id":1071,"date":"2020-09-14T19:15:05","date_gmt":"2020-09-14T12:15:05","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1071"},"modified":"2020-09-30T14:42:28","modified_gmt":"2020-09-30T07:42:28","slug":"ham-int-lay-phan-nguyen-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-int-lay-phan-nguyen-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m INT L\u1ea5y Ph\u1ea7n Nguy\u00ean Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1071\" class=\"elementor elementor-1071\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b613e80 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b613e80\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f840fd4\" data-id=\"f840fd4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-09dada8 elementor-widget elementor-widget-text-editor\" data-id=\"09dada8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m INT l\u00e0 g\u00ec? H\u00e0m INT trong Excel tr\u1ea3 v\u1ec1 ph\u1ea7n nguy\u00ean c\u1ee7a m\u1ed9t s\u1ed1 s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch l\u00e0m tr\u00f2n xu\u1ed1ng.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m INT trong b\u00e0i t\u1eadp Excel v\u00e0 trong c\u00f4ng vi\u1ec7c.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-895c9b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"895c9b0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a5dae57\" data-id=\"a5dae57\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ef34778 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"ef34778\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a29822a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a29822a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f01d14b\" data-id=\"f01d14b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-36ad62c elementor-widget elementor-widget-heading\" data-id=\"36ad62c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-73e59d66-7fff-ed8b-4227-b85b4116d8ea\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1. C\u00f4ng Th\u1ee9c V\u00e0 C\u00e1ch D\u00f9ng H\u00e0m INT Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4e47371 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e47371\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fb6d3f0\" data-id=\"fb6d3f0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f8d66e9 elementor-widget elementor-widget-text-editor\" data-id=\"f8d66e9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u1ec7nh INT trong Excel c\u00f3 c\u00fa ph\u00e1p:<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; font-weight: bold; white-space: pre-wrap; text-align: justify;\">=INT(Number)<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">Trong \u0111\u00f3: Number l\u00e0 s\u1ed1 th\u1ef1c b\u1ea1n mu\u1ed1n l\u1ea5y ph\u1ea7n nguy\u00ean, ho\u1eb7c l\u00e0 ph\u00e9p to\u00e1n nh\u00e2n chia c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n.<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; text-align: justify; white-space: pre-wrap;\">L\u01b0u \u00fd r\u1eb1ng h\u00e0m INT l\u00e0 h\u00e0m l\u1ea5y s\u1ed1 nguy\u00ean l\u00e0m tr\u00f2n xu\u1ed1ng, ch\u00ednh v\u00ec v\u1eady k\u1ebft qu\u1ea3 h\u00e0m INT cho s\u1ed1 \u00e2m c\u00e0ng \u00e2m h\u01a1n.<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap; text-align: justify;\">V\u00ed d\u1ee5: trong khi INT (5.6) tr\u1ea3 v\u1ec1 5, INT(-1.2) tr\u1ea3 v\u1ec1 -2.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-77a0a8e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77a0a8e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1f74652\" data-id=\"1f74652\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b7c000 elementor-widget elementor-widget-image\" data-id=\"6b7c000\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Vi-du-su-dung-ham-int-de-lay-phan-nguyen.png\" title=\"Vi-du-su-dung-ham-int-de-lay-phan-nguyen\" alt=\"C\u00f4ng Th\u1ee9c V\u00e0 C\u00e1ch D\u00f9ng H\u00e0m INT Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-187410e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"187410e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3600a61\" data-id=\"3600a61\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-256f441 elementor-widget elementor-widget-text-editor\" data-id=\"256f441\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">N\u1ebfu \u0111\u1ed1i s\u1ed1 l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c, v\u00ed d\u1ee5 ph\u00e9p chia c\u00f3 s\u1ed1 d\u01b0 th\u00ec INT(10\/3) tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 3.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e13bd3e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e13bd3e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dbafea3\" data-id=\"dbafea3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fc01178 elementor-widget elementor-widget-heading\" data-id=\"fc01178\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-efc8125d-7fff-b137-b845-8df18c4c3091\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2. B\u00e0i T\u1eadp D\u00f9ng H\u00e0m INT Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5da7f6f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5da7f6f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7357cba\" data-id=\"7357cba\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-731afcb elementor-widget elementor-widget-heading\" data-id=\"731afcb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-31cae374-7fff-e819-d4c0-04e9ca681e6d\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.1, S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c L\u1ea5y Ph\u1ea7n Nguy\u00ean Trong Excel \u0110\u1ec3 Quy \u0110\u1ed5i Th\u1eddi Gian<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-58ce44a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"58ce44a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8355de8\" data-id=\"8355de8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b0784cd elementor-widget elementor-widget-text-editor\" data-id=\"b0784cd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00f4ng th\u1ee9c l\u1ea5y ph\u1ea7n nguy\u00ean trong Excel c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng \u0111\u1ec3 quy \u0111\u1ed5i th\u1eddi gian c\u00f3 nhi\u1ec1u \u0111\u01a1n v\u1ecb, v\u00ed d\u1ee5 quy \u0111\u1ed5i 127 ph\u00fat th\u00e0nh s\u1ed1 gi\u1edd v\u00e0 ph\u00fat t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-de83c07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"de83c07\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61b3eb9\" data-id=\"61b3eb9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-455bbbf elementor-widget elementor-widget-text-editor\" data-id=\"455bbbf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u1edbi c\u00e1c s\u1ed1 \u0111\u01a1n gi\u1ea3n ho\u1eb7c c\u00e1c ph\u00e9p chia h\u1ebft, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh nh\u1ea9m trong \u0111\u1ea7u: nh\u01b0 k\u1ebft qu\u1ea3 c\u1ee7a \u00fd tr\u00ean l\u00e0 2 gi\u1edd 7 ph\u00fat.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INT k\u1ebft h\u1ee3p h\u00e0m l\u1ea5y ph\u1ea7n d\u01b0 trong Excel- h\u00e0m MOD \u0111\u1ec3 t\u00ednh to\u00e1n v\u1edbi 1 d\u00e3y c\u00e1c \u0111\u1ed1i s\u1ed1 t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9b1ab0e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b1ab0e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-59d0a8c\" data-id=\"59d0a8c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7253e36 elementor-widget elementor-widget-image\" data-id=\"7253e36\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Vi-du-su-dung-ham-int-de-lay-phan-nguyen-quy-doi-thoi-gian.png\" title=\"Vi-du-su-dung-ham-int-de-lay-phan-nguyen-quy-doi-thoi-gian\" alt=\"S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c L\u1ea5y Ph\u1ea7n Nguy\u00ean Trong Excel \u0110\u1ec3 Quy \u0110\u1ed5i Th\u1eddi Gian\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-71e78df elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"71e78df\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cb382d0\" data-id=\"cb382d0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66af61b elementor-widget elementor-widget-heading\" data-id=\"66af61b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a7674b7c-7fff-6273-93b5-77bb9949731f\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2.2, X\u00e1c \u0110\u1ecbnh S\u1ed1 Ng\u00e0y Gi\u1eefa 2 M\u1ed1c Th\u1eddi Gian \u00c1p D\u1ee5ng T\u00ednh S\u1ed1 Ng\u00e0y L\u01b0u Tr\u00fa<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1bf2477 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1bf2477\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b142fe8\" data-id=\"b142fe8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3d89d12 elementor-widget elementor-widget-text-editor\" data-id=\"3d89d12\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00f3 th\u1ec3 \u00e1p d\u1ee5ng v\u00e0 thay \u0111\u1ed5i c\u00f4ng th\u1ee9c Excel n\u00e0y cho y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c: v\u00ed d\u1ee5 x\u00e1c \u0111\u1ecbnh th\u1eddi gian l\u01b0u tr\u00fa c\u1ee7a kh\u00e1ch t\u1ea1i kh\u00e1ch s\u1ea1n, ho\u1eb7c th\u1eddi gian s\u1eed d\u1ee5ng d\u1ecbch v\u1ee5 n\u1ebfu gi\u00e1 tr\u1ecb d\u1ecbch v\u1ee5 l\u00e0 kh\u00e1c bi\u1ec7t (t\u00ednh theo gi\u1edd \u0111\u1eaft h\u01a1n theo ng\u00e0y n\u1ebfu quy v\u1ec1 c\u00f9ng \u0111\u1ea1i l\u01b0\u1ee3ng)&#8230;.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n: t\u00ednh s\u1ed1 ng\u00e0y v\u00e0 gi\u1edd gi\u1eefa 2 m\u1ed1c th\u1eddi gian.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ea7u ti\u00ean, h\u00e3y c\u00f9ng hoctin.vn th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n t\u1eebng b\u01b0\u1edbc step by step, r\u1ed3i \u0111\u1eb7t c\u00f4ng th\u1ee9c r\u00fat g\u1ecdn sau.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u01b0\u1edbc 1: t\u00ednh s\u1ed1 ng\u00e0y ch\u1eb5n gi\u1eefa 2 m\u1ed1c th\u1eddi gian v\u00e0 s\u1ed1 gi\u1edd ch\u1eb5n gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m n\u00e0y b\u1eb1ng h\u00e0m INT:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5e91f83 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e91f83\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3b8fd30\" data-id=\"3b8fd30\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-40d5644 elementor-widget elementor-widget-image\" data-id=\"40d5644\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Vi-du-su-dung-ham-int-de-lay-phan-nguyen-giua-2-moc-thoi-gian.png\" title=\"Vi-du-su-dung-ham-int-de-lay-phan-nguyen-giua-2-moc-thoi-gian\" alt=\"X\u00e1c \u0110\u1ecbnh S\u1ed1 Ng\u00e0y Gi\u1eefa 2 M\u1ed1c Th\u1eddi Gian \u00c1p D\u1ee5ng T\u00ednh S\u1ed1 Ng\u00e0y L\u01b0u Tr\u00fa B\u1eb1ng H\u00e0m INT\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-032dba1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"032dba1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-be461db\" data-id=\"be461db\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-753feb9 elementor-widget elementor-widget-text-editor\" data-id=\"753feb9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-bc5815d9-7fff-5389-9485-88ab575a8fef\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n l\u1ea5y ph\u1ea7n d\u01b0 trong Excel b\u1eb1ng c\u00e1ch chia l\u1ea5y ph\u1ea7n d\u01b0 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y v\u00e0 gi\u1edd gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d71b16 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d71b16\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c663699\" data-id=\"c663699\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d452fe elementor-widget elementor-widget-image\" data-id=\"4d452fe\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Vi-du-su-dung-ham-int-de-lay-phan-nguyen-giua-2-moc-thoi-gian-ket-qua.png\" title=\"Vi-du-su-dung-ham-int-de-lay-phan-nguyen-giua-2-moc-thoi-gian-ket-qua\" alt=\"Th\u1ef1c hi\u1ec7n l\u1ea5y ph\u1ea7n d\u01b0 trong Excel b\u1eb1ng c\u00e1ch chia l\u1ea5y ph\u1ea7n d\u01b0 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 ng\u00e0y v\u00e0 gi\u1edd gi\u1eefa 2 th\u1eddi \u0111i\u1ec3m t\u1eeb k\u1ebft qu\u1ea3 h\u00e0m INT \u1edf b\u01b0\u1edbc 1\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8f89662 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f89662\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ffc1f6d\" data-id=\"ffc1f6d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-aa38bfb elementor-widget elementor-widget-text-editor\" data-id=\"aa38bfb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 c\u1ee7a v\u00ed d\u1ee5 tr\u00ean l\u00e0 121 ng\u00e0y 14 gi\u1edd.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Tuy nhi\u00ean \u0111\u1ec3 t\u00ednh to\u00e1n cho b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m h\u00e0ng tr\u0103m \u0111\u1ebfn h\u00e0ng ngh\u00ecn m\u1ed1c th\u1eddi gian th\u00ec b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m INT k\u1ebft h\u1ee3p h\u00e0m MOD- h\u00e0m l\u1ea5y ph\u1ea7n d\u01b0 trong Excel v\u1edbi c\u00fa ph\u00e1p h\u00e0m MOD: =MOD(S\u1ed1 b\u1ecb chia, s\u1ed1 chia):<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-014f3ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"014f3ca\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d23e90f\" data-id=\"d23e90f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-62b3bb6 elementor-widget elementor-widget-image\" data-id=\"62b3bb6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/09\/Vi-du-su-dung-ham-int-de-lay-phan-nguyen-giua-2-moc-thoi-gian-cong-thuc-excel-rut-gon.png\" title=\"Vi-du-su-dung-ham-int-de-lay-phan-nguyen-giua-2-moc-thoi-gian-cong-thuc-excel-rut-gon\" alt=\"S\u1eed D\u1ee5ng C\u00f4ng Th\u1ee9c L\u1ea5y Ph\u1ea7n Nguy\u00ean Trong Excel \u0110\u1ec3 Quy \u0110\u1ed5i Th\u1eddi Gian B\u1eb1ng H\u00e0m INT\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2cdeef2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2cdeef2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-63f5b6a\" data-id=\"63f5b6a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1e7464a elementor-widget elementor-widget-text-editor\" data-id=\"1e7464a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i h\u00e0m INT v\u00e0 h\u00e0m MOD, h\u00e0m l\u1ea5y s\u1ed1 l\u1ebb sau d\u1ea5u ph\u1ea9y TRUNC c\u0169ng l\u00e0 m\u1ed9t h\u00e0m th\u00f4ng d\u1ee5ng hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p chia c\u00f3 d\u01b0.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 h\u00e0m INT trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m COUNTIF<\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m IF<\/a><\/p><div>\u00a0<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>H\u00e0m INT l\u00e0 g\u00ec? H\u00e0m INT trong Excel tr\u1ea3 v\u1ec1 ph\u1ea7n nguy\u00ean c\u1ee7a m\u1ed9t s\u1ed1 s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch l\u00e0m tr\u00f2n xu\u1ed1ng. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m INT trong b\u00e0i t\u1eadp Excel v\u00e0 trong c\u00f4ng vi\u1ec7c. M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft 1. C\u00f4ng Th\u1ee9c V\u00e0 C\u00e1ch &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m INT L\u1ea5y Ph\u1ea7n Nguy\u00ean Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-int-lay-phan-nguyen-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m INT L\u1ea5y Ph\u1ea7n Nguy\u00ean Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1089,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[37,39,38,56],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1071"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=1071"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1089"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}