{"id":9791,"date":"2025-01-03T01:48:16","date_gmt":"2025-01-03T01:48:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/cach-tinh-thoi-gian-tren-excel-don-gian-nhat\/"},"modified":"2025-01-03T01:48:16","modified_gmt":"2025-01-03T01:48:16","slug":"cach-tinh-thoi-gian-tren-excel-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/cach-tinh-thoi-gian-tren-excel-don-gian-nhat\/","title":{"rendered":"C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u00ed d\u1ee5 b\u1ea1n c\u00f3 2 c\u1ed9t v\u1ec1 th\u1eddi gian \u0111i. C\u1ed9t A l\u00e0 th\u1eddi gian \u0111\u1ebfn, c\u1ed9t B l\u00e0 th\u1eddi gian \u0111i. T\u1ea5t nhi\u00ean l\u00e0 c\u1ed9t B mu\u1ed9n h\u01a1n c\u1ed9t A r\u1ed3i. V\u1eady l\u00e0m sao \u0111\u1ec3 bi\u1ebft s\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian? Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng c\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/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-677741dfe972e\" 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\/cach-tinh-thoi-gian-tren-excel-don-gian.html#Cach_tinh_thoi_gian_tren_Excel_don_gian_nhat\" title=\"C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\">C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/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\/cach-tinh-thoi-gian-tren-excel-don-gian.html#Cach_tinh_thoi_gian_tren_Excel_di_kem_ngay_thang\" title=\"C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111i k\u00e8m ng\u00e0y th\u00e1ng\">C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111i k\u00e8m ng\u00e0y th\u00e1ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_thoi_gian_tren_Excel_don_gian_nhat\"><\/span>C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00a0<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ch\u00fang ta s\u1ebd gi\u1ea3 s\u1eed d\u1eef li\u1ec7u t\u1ea1i 2 c\u1ed9t ch\u1ec9 bao g\u1ed3m gi\u1edd, ph\u00fat, gi\u00e2y. Ta \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u1ea1i \u00f4\u00a0<strong>C2<\/strong>\u00a0<em>=B2-A2.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23493\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-thoi-gian-1.png\" width=\"347\" height=\"268\" title=\"tinh-thoi-gian-1\"><\/p>\n<p><em>N\u1ebfu k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ch\u1ee9 kh\u00f4ng ph\u1ea3i gi\u1edd ph\u00fat gi\u00e2y, c\u00e1c b\u1ea1n h\u00e3y ch\u1ecdn Format Cells v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Time nh\u00e9!<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_thoi_gian_tren_Excel_di_kem_ngay_thang\"><\/span>C\u00e1ch t\u00ednh th\u1eddi gian tr\u00ean Excel \u0111i k\u00e8m ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p bao g\u1ed3m c\u1ea3 ng\u00e0y th\u00e1ng nh\u01b0 \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y, c\u00e1c b\u1ea1n c\u0169ng \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p><em>C2=B2-A2<\/em><\/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-92.gif\" title=\"ex101_92019-nho-92\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23494\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-thoi-gian-2.png\" width=\"421\" height=\"145\" title=\"tinh-thoi-gian-2\"><\/p>\n<p>Sau \u0111\u00f3, ch\u1ecdn Format Cells, v\u00e0 ta ch\u1ecdn nh\u01b0 h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23495\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-thoi-gian-3.png\" width=\"529\" height=\"478\" title=\"tinh-thoi-gian-3\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 bao g\u1ed3m ch\u00ednh x\u00e1c s\u1ed1 gi\u1edd:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23496\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tinh-thoi-gian-4.png\" width=\"421\" height=\"145\" title=\"tinh-thoi-gian-4\"><\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 h\u00e0m t\u00ednh th\u1eddi gian c\u0169ng nh\u01b0 c\u00e1c c\u00e1ch t\u00ednh \u0111\u01a1n gi\u1ea3n kh\u00e1c trong Excel. C\u1ee5 th\u1ec3 t\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-thoi-gian-tren-excel-cong-tru-gio-phut-giay.html\"><strong>\u0111\u00e2y<\/strong><\/a>.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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\/2025\/01\/ex101_92019-nho-92.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9792,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9791","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\/9791","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=9791"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9791\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9792"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}