{"id":11409,"date":"2025-01-15T03:02:24","date_gmt":"2025-01-15T03:02:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/hien-an-ngay-am-trong-excel\/"},"modified":"2025-01-15T03:02:24","modified_gmt":"2025-01-15T03:02:24","slug":"hien-an-ngay-am-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/hien-an-ngay-am-trong-excel\/","title":{"rendered":"Hi\u1ec7n\/\u1ea8n ng\u00e0y \u00e2m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Khi b\u1ea1n tr\u1eeb th\u1eddi gian sau cho th\u1eddi gian tr\u01b0\u1edbc, v\u00ed d\u1ee5 12:20 \u2013 10:15, b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u1ed7i\u00a0<em><strong>#####\u00a0<\/strong><\/em>nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, l\u00e0m sao \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng trong Excel.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6835\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/untitled-2.png\" width=\"600\" height=\"113\" title=\"untitled-2\"><\/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-6787253fd9426\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/hienan-ngay-trong-excel.html#Hien_thi_ngay_am_bang_cach_thay_doi_he_thong_ngay_thang_mac_dinh_trong_Excel\" title=\"Hi\u1ec3n th\u1ecb ng\u00e0y \u00e2m b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh trong Excel\">Hi\u1ec3n th\u1ecb ng\u00e0y \u00e2m b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/hienan-ngay-trong-excel.html#Hien_thi_thoi_gian_am_bang_cong_thuc\" title=\"Hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m b\u1eb1ng c\u00f4ng th\u1ee9c\">Hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m b\u1eb1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hien_thi_ngay_am_bang_cach_thay_doi_he_thong_ngay_thang_mac_dinh_trong_Excel\"><\/span><strong>Hi\u1ec3n th\u1ecb ng\u00e0y \u00e2m b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng \u0111\u1ec3 hi\u1ec3n th\u1ecb ng\u00e0y \u00e2m b\u00ecnh th\u01b0\u1eddng trong Excel b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng m\u1eb7c \u0111\u1ecbnh th\u00e0nh h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng 1904. Th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">1. M\u1edf h\u1ed9p tho\u1ea1i\u00a0<em><strong>Excel Options<\/strong><\/em>, nh\u1ea5n ch\u1ecdn <em><strong>File &gt; Options\u00a0<\/strong><\/em>trong Excel 2010\/2013, ho\u1eb7c ch\u1ecdn <em><strong>Office Button &gt; Excel Options <\/strong><\/em>trong Excel 2007.<\/p>\n<p style=\"text-align: justify\">2. Trong h\u1ed9p tho\u1ea1i <em><strong>Excel Options<\/strong><\/em>, ch\u1ecdn <em><strong>Advanced\u00a0<\/strong><\/em>t\u1eeb b\u1ea3ng b\u00ean tr\u00e1i. \u1ede ph\u1ea7n b\u00ean ph\u1ea3i, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <em><strong>Use 1904 date system\u00a0<\/strong><\/em>d\u01b0\u1edbi ph\u1ea7n <em><strong>When calculating this workbook<\/strong><\/em>\u00a0nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6836\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-show-negative-time3.png\" width=\"600\" height=\"384\" title=\"doc-show-negative-time3\"><\/p>\n<p style=\"text-align: justify\">3. Sau khi c\u00e0i \u0111\u1eb7t xong, nh\u1ea5n OK. Th\u1eddi gian \u00e2m s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c theo k\u1ebft qu\u1ea3 t\u00ednh ra nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/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\/2025\/01\/ex101_92019-nho-293.gif\" title=\"ex101_92019-nho-293\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6838\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/untitled-3.png\" width=\"600\" height=\"114\" title=\"untitled-3\"><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hien_thi_thoi_gian_am_bang_cong_thuc\"><\/span><strong>Hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n thay \u0111\u1ed5i h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\">1. Nh\u1eadp ng\u00e0y th\u00e1ng mu\u1ed1n t\u00ednh, v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o \u00f4 tr\u1ed1ng <em><strong>=TEXT(MAX($A$1:$A$2)-MIN($A$1:$A$2),\u201d-H::MM\u201d)<\/strong><\/em>\u00a0(A1 v\u00e0 A2 l\u00e0 hai \u00f4 ch\u1ee9a th\u1eddi gian).<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6839\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-show-negative-time5.png\" width=\"600\" height=\"140\" title=\"doc-show-negative-time5\"><\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n Enter, k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6840\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-show-negative-time6.png\" width=\"600\" height=\"129\" title=\"doc-show-negative-time6\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\" target=\"_blank\">h\u00e0m If l\u1ed3ng<\/a> sau c\u0169ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n:\u00a0<em><strong>=IF(A2-A1&lt;0, \u201c-\u201d &amp; TEXT(ABS(A2-A1),\u201dhh:mm\u201d), A2-A1)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c n\u00e0y, A2 l\u00e0 th\u1eddi gian nh\u1ecf h\u01a1n, A1 \u0111\u1ea1i di\u1ec7n cho th\u1eddi gian l\u1edbn h\u01a1n. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ch\u00fang n\u1ebfu b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">\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\/2025\/01\/ex101_92019-nho-293.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11410,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11409","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\/11409","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=11409"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11409\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11410"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}