{"id":13468,"date":"2015-09-17T08:04:20","date_gmt":"2015-09-17T08:04:20","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13468"},"modified":"2015-09-29T09:21:52","modified_gmt":"2015-09-29T09:21:52","slug":"cach-su-dung-cac-ham-thoi-gian-trong-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13468","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1eddi gian trong Excel"},"content":{"rendered":"

\"C\u00e1ch<\/h2>\n

V\u1edbi b\u1ea5t k\u1ef3 c\u00f4ng vi\u1ec7c g\u00ec hay b\u1ea5t c\u1ee9 l\u00fac n\u00e0o ch\u00fang ta c\u0169ng \u0111\u1ec1u c\u1ea7n \u0111\u1ebfn c\u00e1c y\u1ebfu t\u1ed1 v\u1ec1 th\u1eddi gian. Ng\u00e0y th\u00e1ng n\u0103m d\u00f9ng \u0111\u1ec3 s\u1eafp x\u1ebfp l\u1ecbch l\u00e0m vi\u1ec7c, th\u1eddi kh\u00f3a bi\u1ec3u, th\u1eddi gian ghi tr\u00ean c\u00e1c h\u00f3a \u0111\u01a1n ch\u1ee9ng t\u1eeb,\u2026 Th\u1eddi gian, ng\u00e0y th\u00e1ng th\u1ec3 hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o ph\u1ee5 thu\u1ed9c v\u00e0o vi\u1ec7c thi\u1ebft l\u1eadp trong Control panel \u1edf m\u00e1y m\u1ed7i ng\u01b0\u1eddi. Vi\u1ec7c b\u1ea1n c\u00e0i \u0111\u1eb7t nh\u01b0 th\u1ebf n\u00e0o th\u00ec tr\u00ean Excel s\u1ebd hi\u1ec3n th\u1ecb \u0111\u00fang nh\u01b0 v\u1eady.<\/span><\/p>\n

K\u1ebf to\u00e1n Centax<\/strong><\/a> xin gi\u1edbi thi\u1ec7u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1eddi gian trong Excel. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/span><\/p>\n

1. H\u00e0m NOW – h\u00e0m hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 th\u1eddi gian hi\u1ec7n t\u1ea1i<\/span><\/h2>\n

C\u00fa ph\u00e1p: =NOW()<\/span><\/strong><\/p>\n

Khi ta g\u00f5 c\u00fa ph\u00e1p n\u00e0y, trong Excel s\u1ebd cho ra k\u1ebft qu\u1ea3 g\u1ed3m ng\u00e0y, th\u00e1ng, n\u0103m, gi\u1edd, ph\u00fat theo th\u1eddi gian hi\u1ec7n t\u1ea1i \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

2. H\u00e0m TODAY – h\u00e0m hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i<\/span><\/h2>\n

C\u00fa ph\u00e1p: =TODAY()<\/span><\/strong><\/p>\n

Khi ta g\u00f5 c\u00fa ph\u00e1p n\u00e0y, trong Excel s\u1ebd cho k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb l\u00e0 ng\u00e0y, th\u00e1ng, n\u0103m hi\u1ec7n t\u1ea1i theo th\u1eddi gian c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

3. H\u00e0m DAY – h\u00e0m hi\u1ec3n th\u1ecb ng\u00e0y c\u1ea7n l\u1ea5y<\/span><\/h2>\n

C\u00fa ph\u00e1p: =DAY(v\u1ecb tr\u00ed c\u1ee7a bi\u1ec3u th\u1ee9c th\u1eddi gian)<\/span><\/strong><\/p>\n

V\u00ed d\u1ee5: Ta c\u00f3 1 bi\u1ec3u th\u1ee9c th\u1eddi gian l\u00e0 ng\u00e0y 25 th\u00e1ng 11 n\u0103m 2015. <\/span>
\n G\u00f5 c\u00fa ph\u00e1p =DAY(ch\u1ecdn v\u1ecb tr\u00ed bi\u1ec3u th\u1ee9c 25\/11\/2015). Ta s\u1ebd \u0111\u01b0\u1ee3c ph\u1ea7n ng\u00e0y l\u00e0 25<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

4. H\u00e0m MONTH – h\u00e0m hi\u1ec3n th\u1ecb th\u00e1ng c\u1ea7n l\u1ea5y<\/span><\/h2>\n

C\u00fa ph\u00e1p: =MONTH(v\u1ecb tr\u00ed c\u1ee7a bi\u1ec3u th\u1ee9c th\u1eddi gian)<\/span><\/strong><\/p>\n

V\u00ed d\u1ee5: Ta c\u00f3 bi\u1ec3u th\u1ee9c th\u1eddi gian l\u00e0 ng\u00e0y 25\/11\/2015<\/span>
\n G\u00f5 c\u00fa ph\u00e1p: =MONTH(ch\u1ecdn v\u1ecb tr\u00ed bi\u1ec3u th\u1ee9c 25\/11\/2015). Ta s\u1ebd \u0111\u01b0\u1ee3c ph\u1ea7n th\u00e1ng l\u00e0 11<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

5. H\u00e0m YEAR – h\u00e0m hi\u1ec3n th\u1ecb n\u0103m c\u1ea7n l\u1ea5y<\/span><\/h2>\n

C\u00fa ph\u00e1p: =YEAR(v\u1ecb tr\u00ed c\u1ee7a bi\u1ec3u th\u1ee9c th\u1eddi gian)<\/span><\/strong><\/p>\n

\"C\u00e1ch<\/p>\n

6. H\u00e0m DATE – h\u00e0m d\u00f9ng \u0111\u1ec3 gh\u00e9p ng\u00e0y th\u00e1ng n\u0103m<\/span><\/h2>\n

Khi ta ch\u00fang ta c\u00f3 1 bi\u1ec3u th\u1ee9c th\u1eddi gian t\u00e1ch r\u1eddi mu\u1ed1n gh\u00e9p l\u1ea1i th\u00ec ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m DATE<\/span><\/p>\n

C\u00fa ph\u00e1p: =DATE(n\u0103m,th\u00e1ng,ng\u00e0y)<\/span><\/strong><\/p>\n

\"C\u00e1ch<\/p>\n

7. H\u00e0m WEEKDAY – h\u00e0m hi\u1ec3n th\u1ecb th\u1ee9 trong tu\u1ea7n<\/span><\/h2>\n

Khi ta c\u00f3 m\u1ed9t bi\u1ec3u th\u1ee9c th\u1eddi gian, ta mu\u1ed1n xem ng\u00e0y \u0111\u00f3 l\u00e0 th\u1ee9 m\u1ea5y trong tu\u1ea7n th\u00ec ta s\u1ebd d\u00f9ng h\u00e0m WEEKDAY.<\/span><\/p>\n

C\u00fa ph\u00e1p: =WEEKDAY(v\u1ecb tr\u00ed bi\u1ec3u th\u1ee9c ng\u00e0y th\u00e1ng n\u0103m)<\/span><\/strong><\/p>\n

\"C\u00e1ch<\/p>\n","protected":false},"excerpt":{"rendered":"

C\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1eddi gian trong Excel nh\u01b0 th\u1ebf n\u00e0o? Sau \u0111\u00e2y k\u1ebf to\u00e1n Centax xin chia s\u1ebb t\u1edbi b\u1ea1n \u0111\u1ecdc trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. M\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13485,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1691],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13468"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13468"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13468\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13485"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13468"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}