{"id":4429,"date":"2024-12-05T09:38:55","date_gmt":"2024-12-05T09:38:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/huong-dan-cach-cong-gio-phut-trong-excel-don-gian-nhanh-chong\/"},"modified":"2024-12-05T09:38:55","modified_gmt":"2024-12-05T09:38:55","slug":"huong-dan-cach-cong-gio-phut-trong-excel-don-gian-nhanh-chong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/huong-dan-cach-cong-gio-phut-trong-excel-don-gian-nhanh-chong\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed9ng gi\u1edd ph\u00fat trong Excel \u0111\u01a1n gi\u1ea3n nhanh ch\u00f3ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Th\u00f4ng th\u01b0\u1eddng, s\u1ebd c\u00f3 2 c\u00e1ch \u0111\u1ec3 c\u1ed9ng ho\u1eb7c tr\u1eeb c\u00e1c kho\u1ea3ng th\u1eddi gian trong Excel: s\u1eed d\u1ee5ng h\u00e0m TIME ho\u1eb7c d\u00f9ng c\u00e1c ph\u00e9p to\u00e1n logic d\u1ef1a theo 24 gi\u1edd, 1440 ph\u00fat v\u00e0 86400 gi\u00e2y trong m\u1ed9t ng\u00e0y. N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u c\u00f3 c\u00e1c kho\u1ea3ng th\u1eddi gian l\u1edbn, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c\u00a0c\u1ed9ng gi\u1edd ph\u00fat trong\u00a0Excel sau.<\/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-675174aedcb4b\" 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\/cach-tinh-thoi-gian-tren-excel-cong-tru-gio-phut-giay.html#Cong_gio_phut_trong_Excel\" title=\"C\u1ed9ng gi\u1edd ph\u00fat trong Excel\">C\u1ed9ng gi\u1edd ph\u00fat trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-tren-excel-cong-tru-gio-phut-giay.html#Su_dung_ham_TIME_de_cong_gio_nho_hon_24\" title=\"S\u1eed d\u1ee5ng h\u00e0m TIME \u0111\u1ec3 c\u1ed9ng gi\u1edd nh\u1ecf h\u01a1n 24\">S\u1eed d\u1ee5ng h\u00e0m TIME \u0111\u1ec3 c\u1ed9ng gi\u1edd nh\u1ecf h\u01a1n 24<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-tren-excel-cong-tru-gio-phut-giay.html#Cach_tinh_thoi_gian_tren_Excel_su_dung_cong_thuc_cho_bat_ky_gio_nao\" title=\"C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cho b\u1ea5t k\u1ef3 gi\u1edd n\u00e0o\">C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cho b\u1ea5t k\u1ef3 gi\u1edd n\u00e0o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-tren-excel-cong-tru-gio-phut-giay.html#Cong_tru_phut_trong_Excel\" title=\"C\u1ed9ng tr\u1eeb ph\u00fat trong Excel\">C\u1ed9ng tr\u1eeb ph\u00fat trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-tren-excel-cong-tru-gio-phut-giay.html#Su_dung_ham_TIME_cong_tru_phut_nho_hon_1_ngay\" title=\"S\u1eed d\u1ee5ng h\u00e0m TIME c\u1ed9ng tr\u1eeb ph\u00fat nh\u1ecf h\u01a1n 1 ng\u00e0y\">S\u1eed d\u1ee5ng h\u00e0m TIME c\u1ed9ng tr\u1eeb ph\u00fat nh\u1ecf h\u01a1n 1 ng\u00e0y<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_gio_phut_trong_Excel\"><\/span>C\u1ed9ng gi\u1edd ph\u00fat trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 c\u1ed9ng gi\u1edd v\u1edbi m\u1ed9t th\u1eddi gian c\u00f3 s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo nh\u1eefng c\u00e1ch sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_TIME_de_cong_gio_nho_hon_24\"><\/span>S\u1eed d\u1ee5ng h\u00e0m TIME \u0111\u1ec3 c\u1ed9ng gi\u1edd nh\u1ecf h\u01a1n 24<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p>=<strong>Th\u1eddi gian<\/strong><strong>\u00a0b\u1eaft \u0111\u1ea7u\u00a0<\/strong>+\u00a0<strong>TIME(x gi\u1edd, 0, 0)<\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5: \u0110\u1ec3 c\u1ed9ng th\u00eam 2 ti\u1ebfng v\u00e0o th\u1eddi gian c\u00f3 s\u1eb5n \u1edf \u00f4 A1, t\u1ea1i \u00f4 B1\u00a0b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23256\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-1.png\" width=\"427\" height=\"129\" title=\"time-1\"><\/p>\n<p><em>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n c\u1ed9ng gi\u1edd l\u1edbn h\u01a1n 24, h\u00e0m TIME s\u1ebd chia cho 24 ti\u1ebfng \u0111\u1ec3 tr\u1ea3 v\u1ec1 th\u1eddi gian trong ng\u00e0y. \u0110i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0, trong v\u00ed d\u1ee5,\u00a0<strong>A1+TIME(2,0,0)\u00a0<\/strong>v\u00e0\u00a0<strong>A1+TIME(26,0,0)\u00a0<\/strong>ch\u1eb3ng kh\u00e1c g\u00ec nhau c\u1ea3.<\/em><\/p>\n<p><em><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23257\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-2.png\" width=\"490\" height=\"76\" title=\"time-2\"><\/em>V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed9ng\/tr\u1eeb th\u1eddi gian l\u1edbn h\u01a1n 1 ng\u00e0y \u0111\u00e2y? H\u00e3y \u0111\u1ebfn v\u1edbi c\u00e1ch th\u1ee9 hai:\u00a0C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_thoi_gian_tren_Excel_su_dung_cong_thuc_cho_bat_ky_gio_nao\"><\/span>C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c cho b\u1ea5t k\u1ef3 gi\u1edd n\u00e0o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 gi\u1edd m\u00e0 b\u1ea1n nh\u1eadp v\u00e0o:<\/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-359.gif\" title=\"ex101_92019-nho-359\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>=<strong>Th\u1eddi gian<\/strong><strong>\u00a0b\u1eaft \u0111\u1ea7u\u00a0<\/strong>+ (<strong>x gi\u1edd \/ 24)<\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 c\u1ed9ng th\u00eam 26 ti\u1ebfng, ta l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23261\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-3.png\" width=\"491\" height=\"169\" title=\"time-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_tru_phut_trong_Excel\"><\/span>C\u1ed9ng tr\u1eeb ph\u00fat trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u1ed9ng tr\u1eeb theo ph\u00fat trong Excel ta l\u00e0m theo m\u1ed9t trong nh\u1eefng c\u00e1ch sau:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ham_TIME_cong_tru_phut_nho_hon_1_ngay\"><\/span>S\u1eed d\u1ee5ng h\u00e0m TIME c\u1ed9ng tr\u1eeb ph\u00fat nh\u1ecf h\u01a1n 1 ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<blockquote>\n<p><strong>=Th\u1eddi gian b\u1eaft \u0111\u1ea7u + TIME(0, x ph\u00fat, 0)<\/strong><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23264\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-4.png\" width=\"492\" height=\"278\" title=\"time-4\"><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi gi\u1edd, h\u00e0m\u00a0<strong>TIME<\/strong> b\u1ecb gi\u1edbi h\u1ea1n trong s\u1ed1 ph\u00fat. B\u1edfi v\u1eady, n\u1ebfu mu\u1ed1n c\u1ed9ng s\u1ed1 ph\u00fat l\u1edbn h\u01a1n 60, ta c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<blockquote>\n<p><strong>=Th\u1eddi gian b\u1eaft \u0111\u1ea7u + (x ph\u00fat \/ 1440)<\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23265\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-5.png\" width=\"480\" height=\"105\" title=\"time-5\"><\/p>\n<p>C\u1ed9ng tr\u1eeb th\u1eddi gian theo gi\u00e2y trong Excel<\/p>\n<p>Nh\u01b0 \u0111\u1ed1i v\u1edbi gi\u1edd v\u00e0 ph\u00fat, ta c\u0169ng s\u1eed d\u1ee5ng hai c\u00e1ch \u0111\u1ec3 t\u00ednh to\u00e1n th\u1eddi gian theo gi\u00e2y trong Excel.<\/p>\n<p><strong>C\u00e1ch 1: H\u00e0m TIME<\/strong><\/p>\n<blockquote>\n<p>=<strong>Th\u1eddi gian b\u1eaft \u0111\u1ea7u + Time(0,0, x gi\u00e2y)\u00a0<\/strong>{x &lt;60}<\/p>\n<\/blockquote>\n<p><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/strong><\/p>\n<blockquote>\n<p>=<strong>Th\u1eddi gian b\u1eaft \u0111\u1ea7u + (x gi\u00e2y \/ 86400)<\/strong><\/p>\n<\/blockquote>\n<p><em>T\u1ea1i sao l\u1ea1i l\u00e0\u00a0<strong>86400<\/strong>? B\u1edfi v\u00ec 1 ng\u00e0y c\u00f3 86400 gi\u00e2y.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-6.png\" width=\"916\" height=\"107\" title=\"time-6\"><\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o. H\u1ecdc Excel Online ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch th\u1ef1c hi\u1ec7n <a href=\"http:\/\/blog.ezworkapp.com\/cach-cong-tru-ngay-thang-nam-trong-excel.html\">ng\u00e0y tr\u1eeb ng\u00e0y trong Excel<\/a><\/strong><\/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-359.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4430,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4429","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\/4429","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=4429"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4429\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4430"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}