{"id":8621,"date":"2024-12-23T00:37:32","date_gmt":"2024-12-23T00:37:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/gioi-thieu-ham-now-tinh-thoi-gian-hien-tai-trong-excel\/"},"modified":"2024-12-23T00:37:32","modified_gmt":"2024-12-23T00:37:32","slug":"gioi-thieu-ham-now-tinh-thoi-gian-hien-tai-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/gioi-thieu-ham-now-tinh-thoi-gian-hien-tai-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u h\u00e0m NOW t\u00ednh th\u1eddi gian hi\u1ec7n t\u1ea1i trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n <strong>h\u00e0m NOW trong Excel<\/strong> d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 ng\u00e0y v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6768b0cbc0629\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-now-tinh-thoi-gian-hien-tai.html#Ham_NOW_tinh_thoi_gian_hien_tai_trong_Excel\" title=\"H\u00e0m NOW t\u00ednh th\u1eddi gian hi\u1ec7n t\u1ea1i trong Excel\">H\u00e0m NOW t\u00ednh th\u1eddi gian hi\u1ec7n t\u1ea1i trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-now-tinh-thoi-gian-hien-tai.html#Cong_thuc_ham_NOW_trong_Excel\" title=\"C\u00f4ng th\u1ee9c h\u00e0m NOW trong Excel\">C\u00f4ng th\u1ee9c h\u00e0m NOW trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-now-tinh-thoi-gian-hien-tai.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_NOW_tinh_thoi_gian_hien_tai_trong_Excel\"><\/span>H\u00e0m NOW t\u00ednh th\u1eddi gian hi\u1ec7n t\u1ea1i trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m NOW s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 series c\u1ee7a ng\u00e0y th\u00e1ng\u00a0(Date) v\u00e0 th\u1eddi gian (Time) hi\u1ec7n t\u1ea1i. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb ng\u00e0y gi\u1edd hi\u1ec7n t\u1ea1i trong trang t\u00ednh ho\u1eb7c t\u00ednh to\u00e1n d\u1ef1a v\u00e0o ng\u00e0y gi\u1edd hi\u1ec7n t\u1ea1i, \u0111\u1ed3ng th\u1eddi li\u00ean t\u1ee5c update gi\u00e1 tr\u1ecb theo th\u1eddi gian.<\/p>\n<p>L\u01b0u \u00fd: N\u1ebfu h\u00e0m NOW kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi trang t\u00ednh, c\u00f3 th\u1ec3 \u0111\u00f3 l\u00e0 do ch\u1ee9c n\u0103ng\u00a0<strong>recalculate<\/strong> \u0111\u00e3 b\u1ecb t\u1eaft \u0111i. Ta c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh b\u1eb1ng c\u00e1ch v\u00e0o\u00a0<strong>Formula -&gt; Calculation Options.<\/strong><\/p>\n<figure id=\"attachment_27425\" aria-describedby=\"caption-attachment-27425\" style=\"width: 192px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27425 size-full\" title=\"GI\u1edaI THI\u1ec6U H\u00c0M NOW T\u00cdNH TH\u1edcI GIAN HI\u1ec6N T\u1ea0I TRONG EXCEL\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-now-1.png\" alt=\"GI\u1edaI THI\u1ec6U H\u00c0M NOW T\u00cdNH TH\u1edcI GIAN HI\u1ec6N T\u1ea0I TRONG EXCEL\" width=\"192\" height=\"104\"><figcaption id=\"caption-attachment-27425\" class=\"wp-caption-text\">GI\u1edaI THI\u1ec6U H\u00c0M NOW\u00a0<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_NOW_trong_Excel\"><\/span>C\u00f4ng th\u1ee9c <strong>h\u00e0m NOW trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m NOW c\u00f3 c\u00fa ph\u00e1p r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n<blockquote>\n<p><strong><em>=NOW()<\/em><\/strong><\/p>\n<\/blockquote>\n<p>Excel c\u00f3 c\u00f4ng th\u1ee9c\u00a0t\u00ednh th\u1eddi gian nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 1, quy \u0111\u1ed5i v\u1ec1 ng\u00e0y th\u00e1ng n\u0103m: 1\/1\/1900. M\u1ed7i ng\u00e0y t\u0103ng 1 s\u1ed1.<\/li>\n<li>B\u1eaft \u0111\u1ea7u t\u1eeb 0 t\u1edbi 1, quy \u0111\u1ed5i v\u1ec1 th\u1eddi gian. VD: 0.5 t\u01b0\u01a1ng \u1ee9ng v\u1edbi 12h tr\u01b0a.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ta c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng h\u00e0m NOW trong 1 s\u1ed1 tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<p><em>=NOW() -&gt;\u00a0<\/em>tr\u1ea3 v\u1ec1 ng\u00e0y gi\u1edd hi\u1ec7n t\u1ea1i.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-797.gif\" title=\"ex101_92019-nho-797\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>=NOW() \u2013 0.5 -&gt;\u00a0<\/em>tr\u1ea3 v\u1ec1 th\u1eddi gian c\u1ee7a 12 ti\u1ebfng tr\u01b0\u1edbc<\/p>\n<p><em>=NOW() + 7 -&gt;\u00a0<\/em>tr\u1ea3 v\u1ec1 th\u1eddi gian c\u1ee7a 7 ng\u00e0y sau<\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m li\u00ean quan kh\u00e1c sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html\"><strong>B\u00e0i t\u1eadp x\u00e1c \u0111\u1ecbnh ng\u00e0y th\u00e1ng n\u0103m b\u1eb1ng h\u00e0m th\u1eddi gian<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-thoi-gian-thong-dung-trong-excel.html\"><strong>H\u00e0m th\u1eddi gian th\u00f4ng d\u1ee5ng trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html\"><strong>\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-797.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8622,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8621","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\/8621","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=8621"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8621\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8622"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}