{"id":45,"date":"2025-02-13T07:58:45","date_gmt":"2025-02-13T00:58:45","guid":{"rendered":"https:\/\/namns.i234.me\/ns\/?p=45"},"modified":"2025-02-13T07:59:08","modified_gmt":"2025-02-13T00:59:08","slug":"cac-ham-excel-hay","status":"publish","type":"post","link":"https:\/\/namns.i234.me\/ns\/cac-ham-excel-hay\/","title":{"rendered":"C\u00e1c h\u00e0m excel hay."},"content":{"rendered":"\n<p>H\u00e0m \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng trong kho\u1ea3ng ng\u00e0y th\u00e1ng:<\/p>\n\n\n\n<p>=COUNTIFS(Q2:Q4,&#8221;>=&#8221;&amp;DATE(2024,8,31),Q2:Q4,&#8221;&lt;=&#8221;&amp;DATE(2024,9,30))<\/p>\n\n\n\n<p>H\u00e0m so s\u00e1nh gi\u1edd trong hai kho\u1ea3ng gi\u1edd c\u00f3 n\u1eb1m trong \u0111\u00f3 kh\u00f4ng. N\u1ebfu n\u1eb1m trong tr\u1ea3 k\u1ebft qu\u1ea3 &#8220;Trong gi\u1edd&#8221;; n\u1eb1m ngo\u00e0i th\u00ec tr\u1ea3 &#8220;Ngo\u00e0i gi\u1edd&#8221;<\/p>\n\n\n\n<p>C\u1ed9t gi\u1edd \u0111\u1ed5i th\u00e0nh: =TIMEVALUE(MID(A1, 12, 8)) C\u1ed9ng So s\u00e1nh v\u1edbi c\u1ed9t gi\u1edd \u0111\u1ed5i th\u00e0nh: =IF(OR(AND(BI2>=TIME(7,15,0), BI2&lt;=TIME(11,45,0)), AND(BI2>=TIME(13,15,0), BI2&lt;=TIME(16,45,0))), &#8220;Trong gi\u1edd&#8221;, &#8220;Ngo\u00e0i gi\u1edd&#8221;)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng trong kho\u1ea3ng ng\u00e0y th\u00e1ng: =COUNTIFS(Q2:Q4,&#8221;>=&#8221;&amp;DATE(2024,8,31),Q2:Q4,&#8221;&lt;=&#8221;&amp;DATE(2024,9,30)) H\u00e0m so s\u00e1nh gi\u1edd trong hai kho\u1ea3ng gi\u1edd c\u00f3 n\u1eb1m trong \u0111\u00f3 kh\u00f4ng. N\u1ebfu n\u1eb1m trong tr\u1ea3 k\u1ebft qu\u1ea3 &#8220;Trong gi\u1edd&#8221;; n\u1eb1m ngo\u00e0i th\u00ec tr\u1ea3 &#8220;Ngo\u00e0i gi\u1edd&#8221; C\u1ed9t gi\u1edd \u0111\u1ed5i th\u00e0nh: =TIMEVALUE(MID(A1, 12, 8)) C\u1ed9ng So s\u00e1nh v\u1edbi c\u1ed9t gi\u1edd \u0111\u1ed5i th\u00e0nh: =IF(OR(AND(BI2>=TIME(7,15,0), BI2&lt;=TIME(11,45,0)), AND(BI2>=TIME(13,15,0), BI2&lt;=TIME(16,45,0))),&#8230;<\/p>\n","protected":false},"author":1,"featured_media":46,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,2],"tags":[],"class_list":["post-45","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/namns.i234.me\/ns\/wp-content\/uploads\/2025\/02\/excel-hay.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts\/45","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/comments?post=45"}],"version-history":[{"count":1,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts\/45\/revisions"}],"predecessor-version":[{"id":50,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts\/45\/revisions\/50"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/media\/46"}],"wp:attachment":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/media?parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/categories?post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/tags?post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}