{"id":5435,"date":"2024-12-16T02:40:45","date_gmt":"2024-12-16T02:40:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/tra-cuu-thoi-gian-bang-vba\/"},"modified":"2024-12-16T02:40:45","modified_gmt":"2024-12-16T02:40:45","slug":"tra-cuu-thoi-gian-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/tra-cuu-thoi-gian-bang-vba\/","title":{"rendered":"Tra c\u1ee9u th\u1eddi gian b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong\u00a0Excel ch\u00fang ta bi\u1ebft t\u1edbi nh\u1eefng h\u00e0m x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian hi\u1ec7n t\u1ea1i nh\u01b0 h\u00e0m Today, h\u00e0m Now. V\u1eady th\u00ec trong VBA ch\u00fang ta x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian hi\u1ec7n t\u1ea1i nh\u01b0 th\u1ebf n\u00e0o? Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y nh\u00e9.<\/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-675f932c82187\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tra-cuu-thoi-gian-bang-vba.html#1_Nhung_doi_tuong_xac_dinh_thoi_gian_trong_VBA\" title=\"1. Nh\u1eefng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian trong VBA\">1. Nh\u1eefng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian trong VBA<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tra-cuu-thoi-gian-bang-vba.html#2_Ung_dung_xac_dinh_thoi_gian_thuc_hien_1_cau_lenh_VBA\" title=\"2.\u00a0\u1ee8ng d\u1ee5ng x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian th\u1ef1c hi\u1ec7n 1 c\u00e2u l\u1ec7nh VBA\">2.\u00a0\u1ee8ng d\u1ee5ng x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian th\u1ef1c hi\u1ec7n 1 c\u00e2u l\u1ec7nh VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Nhung_doi_tuong_xac_dinh_thoi_gian_trong_VBA\"><\/span>1. Nh\u1eefng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian trong VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>X\u00e1c\u00a0\u0111\u1ecbnh Ng\u00e0y hi\u1ec7n t\u1ea1i<\/strong><\/p>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y hi\u1ec7n t\u1ea1i trong VBA th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng DATE ch\u1ee9 kh\u00f4ng ph\u1ea3i TODAY. C\u00e2u l\u1ec7nh g\u1ecdi gi\u00e1 tr\u1ecb ng\u00e0y hi\u1ec7n t\u1ea1i nh\u01b0 sau:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/e66a8ff1f8bf773ec714fc4b48f58862\">Gist<\/a>.<\/div>\n<p><strong>X\u00e1c\u00a0\u00a0\u0111\u1ecbnh Ng\u00e0y+Gi\u1edd hi\u1ec7n t\u1ea1i<\/strong><\/p>\n<p>S\u1eed d\u1ee5ng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 NOW, t\u01b0\u01a1ng t\u1ef1 h\u00e0m NOW trong\u00a0Excel<\/p>\n<p>C\u00e2u l\u1ec7nh g\u1ecdi gi\u00e1 tr\u1ecb ng\u00e0y gi\u1edd hi\u1ec7n t\u1ea1i nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-191.gif\" title=\"vba101_92019-nho-191\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-470.gif\" title=\"ex101_92019-nho-470\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/566269d1c3fef88897513325308e8a38\">Gist<\/a>.<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2_Ung_dung_xac_dinh_thoi_gian_thuc_hien_1_cau_lenh_VBA\"><\/span>2.\u00a0\u1ee8ng d\u1ee5ng x\u00e1c\u00a0\u0111\u1ecbnh th\u1eddi gian th\u1ef1c hi\u1ec7n 1 c\u00e2u l\u1ec7nh VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i m\u1ed7i th\u1eddi\u00a0\u0111i\u1ec3m b\u1eaft\u00a0\u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac m\u1ed7i c\u00e2u l\u1ec7nh th\u00ec gi\u00e1 tr\u1ecb th\u1eddi gian x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi NOW l\u00e0 kh\u00e1c nhau. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 d\u1ef1a v\u00e0o\u00a0\u0111i\u1ec1u\u00a0n\u00e0y\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ed9 ch\u00eanh l\u1ec7ch th\u1eddi gian khi b\u1eaft\u00a0\u0111\u1ea7u v\u00e0 khi k\u1ebft th\u00fac 1 c\u00e2u l\u1ec7nh.\u00a0\u0110\u00f3 ch\u00ednh l\u00e0 th\u1eddi gian VBA th\u1ef1c hi\u1ec7n xong c\u00e2u l\u1ec7nh\u00a0\u0111\u00f3.<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/73cd994e498e3ed4184e480b7f07477f\">Gist<\/a>.<\/div>\n<p>Bi\u1ebfn\u00a0 \u201ct\u201d l\u00e0 th\u1eddi\u00a0\u0111i\u1ec3m b\u1eaft\u00a0\u0111\u1ea7u, khi g\u00e1n bi\u1ebfn t cho th\u1eddi\u00a0\u0111i\u1ec3m\u00a0\u0111\u00f3 th\u00ec gi\u00e1 tr\u1ecb th\u1eddi\u00a0\u0111i\u1ec3m\u00a0\u0111\u00f3 s\u1ebd\u00a0\u0111\u01b0\u1ee3c ghi nh\u1eadn v\u00e0 c\u1ed1\u00a0\u0111\u1ecbnh l\u1ea1i.<\/p>\n<p>Khi k\u1ebft th\u00fac c\u00e2u l\u1ec7nh th\u00ec gi\u00e1 tr\u1ecb Now s\u1ebd thay\u00a0\u0111\u1ed5i. Now() \u2013 t s\u1ebd th\u1ec3 hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c\u00a0\u00a0\u0111\u1ed9 l\u1ec7ch gi\u1eefa 2 kho\u1ea3ng th\u1eddi gian.<\/p>\n<p>Format l\u1ea1i gi\u00e1 tr\u1ecb hi\u1ec7u c\u1ee7a 2 kho\u1ea3ng th\u1eddi gian v\u1ec1 d\u1ea1ng gi\u1edd:ph\u00fat:gi\u00e2y\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh c\u1ee5 th\u1ec3\u00a0\u0111\u1ed9 l\u1ec7ch th\u1eddi gian.<\/p>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng bi\u1ebfn th\u1eddi gian trong VBA r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n. B\u1ea1n ch\u1ec9 c\u1ea7n g\u00e1n gi\u00e1 tr\u1ecb th\u1eddi gian\u00a0\u0111\u00f3 v\u00e0o bi\u1ebfn. T\u1ea1i th\u1eddi\u00a0\u0111i\u1ec3m g\u00e1n th\u00ec gi\u00e1 tr\u1ecb th\u1eddi gian\u00a0\u0111\u00f3 s\u1ebd\u00a0\u0111\u01b0\u1ee3c l\u01b0u l\u1ea1i v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u00e0o v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 sau khi g\u00e1n.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-191.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5435","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=5435"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5435\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5436"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}