{"id":1925,"date":"2024-12-02T06:34:38","date_gmt":"2024-12-02T06:34:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian\/"},"modified":"2024-12-02T06:34:38","modified_gmt":"2024-12-02T06:34:38","slug":"cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian\/","title":{"rendered":"C\u00e1ch t\u00ednh th\u1eddi gian trong Excel \u2013 ch\u00eanh l\u1ec7ch th\u1eddi gian, c\u1ed9ng\/tr\u1eeb th\u1eddi gian"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn nh\u1eefng c\u00f4ng th\u1ee9c h\u1eefu \u00edch \u0111\u1ec3 c\u1ed9ng\/tr\u1eeb th\u1eddi gian, ch\u00eanh l\u1ec7ch th\u1eddi gian, \u0111\u1ebfm gi\u1edd; c\u00e1ch c\u1ed9ng tr\u1eeb th\u1eddi gian trong excel.<\/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-674d54fc9db59\" 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<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_tinh_chenh_lech_thoi_gian_trong_Excel\" title=\"C\u00e1ch t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian trong Excel\">C\u00e1ch t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian 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-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_1_Tru_thoi_gian\" title=\"C\u00f4ng th\u1ee9c 1. Tr\u1eeb th\u1eddi gian\">C\u00f4ng th\u1ee9c 1. Tr\u1eeb th\u1eddi gian<\/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-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_2_Tinh_chenh_lech_thoi_gian_bang_ham_TEXT\" title=\"C\u00f4ng th\u1ee9c 2. T\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian b\u1eb1ng h\u00e0m TEXT\">C\u00f4ng th\u1ee9c 2. T\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian b\u1eb1ng h\u00e0m TEXT<\/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-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_3_Tinh_gio_phut_giay_giua_hai_thoi_gian\" title=\"C\u00f4ng th\u1ee9c 3. T\u00ednh gi\u1edd, ph\u00fat, gi\u00e2y gi\u1eefa hai th\u1eddi gian\">C\u00f4ng th\u1ee9c 3. T\u00ednh gi\u1edd, ph\u00fat, gi\u00e2y gi\u1eefa hai th\u1eddi gian<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_4_Tinh_chenh_lech_thoi_gian_trong_cung_mot_don_vi_thoi_gian_va_bo_qua_cac_don_vi_khac\" title=\"C\u00f4ng th\u1ee9c 4. T\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian trong c\u00f9ng m\u1ed9t \u0111\u01a1n v\u1ecb th\u1eddi gian v\u00e0 b\u1ecf qua c\u00e1c \u0111\u01a1n v\u1ecb kh\u00e1c\u00a0\u00a0 \">C\u00f4ng th\u1ee9c 4. T\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian trong c\u00f9ng m\u1ed9t \u0111\u01a1n v\u1ecb th\u1eddi gian v\u00e0 b\u1ecf qua c\u00e1c \u0111\u01a1n v\u1ecb kh\u00e1c\u00a0\u00a0 <\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_5_Tinh_thoi_gian_troi_qua_ke_tu_thoi_gian_bat_dau_den_bay_gio\" title=\"C\u00f4ng th\u1ee9c 5. T\u00ednh th\u1eddi gian tr\u00f4i qua k\u1ec3 t\u1eeb th\u1eddi gian b\u1eaft \u0111\u1ea7u \u0111\u1ebfn b\u00e2y gi\u1edd\">C\u00f4ng th\u1ee9c 5. T\u00ednh th\u1eddi gian tr\u00f4i qua k\u1ec3 t\u1eeb th\u1eddi gian b\u1eaft \u0111\u1ea7u \u0111\u1ebfn b\u00e2y gi\u1edd<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_6_Hien_thi_chenh_lech_thoi_gian_%E2%80%9CXX_days_XX_hours_XX_minutes_and_XX_seconds%E2%80%9D\" title=\"C\u00f4ng th\u1ee9c 6. Hi\u1ec3n th\u1ecb ch\u00eanh l\u1ec7ch th\u1eddi gian \u201cXX days, XX hours, XX minutes and XX seconds\u201d\">C\u00f4ng th\u1ee9c 6. Hi\u1ec3n th\u1ecb ch\u00eanh l\u1ec7ch th\u1eddi gian \u201cXX days, XX hours, XX minutes and XX seconds\u201d<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_tinh_va_hien_thi_thoi_gian_am_trong_Excel\" title=\"C\u00e1ch t\u00ednh v\u00e0 hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m trong Excel\">C\u00e1ch t\u00ednh v\u00e0 hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m 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-9\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Phuong_phap_1_Thay_doi_he_thong_ngay_thang_cua_Excel_thanh_1904_date_system\" title=\"Ph\u01b0\u01a1ng ph\u00e1p 1. Thay \u0111\u1ed5i h\u1ec7 th\u00f4ng ng\u00e0y th\u00e1ng c\u1ee7a Excel th\u00e0nh 1904 date system\">Ph\u01b0\u01a1ng ph\u00e1p 1. Thay \u0111\u1ed5i h\u1ec7 th\u00f4ng ng\u00e0y th\u00e1ng c\u1ee7a Excel th\u00e0nh 1904 date system<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Phuong_phap_2_Tinh_toan_thoi_gian_am_bang_cong_thuc\" title=\"Ph\u01b0\u01a1ng ph\u00e1p 2. T\u00ednh to\u00e1n th\u1eddi gian \u00e2m b\u1eb1ng c\u00f4ng th\u1ee9c\">Ph\u01b0\u01a1ng ph\u00e1p 2. T\u00ednh to\u00e1n th\u1eddi gian \u00e2m b\u1eb1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Congtru_thoi_gian_trong_Excel\" title=\"C\u1ed9ng\/tr\u1eeb th\u1eddi gian trong Excel\">C\u1ed9ng\/tr\u1eeb th\u1eddi gian 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-12\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Congtru_gio_vao_thoi_gian_cu_the\" title=\"C\u1ed9ng\/tr\u1eeb gi\u1edd v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3\">C\u1ed9ng\/tr\u1eeb gi\u1edd v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_thuc_de_cong_bat_ky_so_gio_nao_duoitren_24_gio\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 c\u1ed9ng b\u1ea5t k\u1ef3 s\u1ed1 gi\u1edd n\u00e0o (d\u01b0\u1edbi\/tr\u00ean 24 gi\u1edd)\">C\u00f4ng th\u1ee9c \u0111\u1ec3 c\u1ed9ng b\u1ea5t k\u1ef3 s\u1ed1 gi\u1edd n\u00e0o (d\u01b0\u1edbi\/tr\u00ean 24 gi\u1edd)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_congtru_phut_vao_thoi_gian_cu_the\" title=\"C\u00e1ch c\u1ed9ng\/tr\u1eeb ph\u00fat v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3\">C\u00e1ch c\u1ed9ng\/tr\u1eeb ph\u00fat v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_congtru_giay_vao_thoi_gian_cu_the\" title=\"C\u00e1ch c\u1ed9ng\/tr\u1eeb gi\u00e2y v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3\">C\u00e1ch c\u1ed9ng\/tr\u1eeb gi\u00e2y v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_cong_thoi_gian_trong_Excel\" title=\"C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel\">C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_hien_thi_khoang_thoi_gian_lon_hon_24_gio_60_phut_60_giay\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y?\">C\u00e1ch hi\u1ec3n th\u1ecb kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y?<\/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-18\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cach_cong_tru_thoi_gian_lon_hon_24_gio_60_phut_60_giay\" title=\"C\u00e1ch c\u1ed9ng tr\u1eeb th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y\">C\u00e1ch c\u1ed9ng tr\u1eeb th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y<\/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-19\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_hon_24_gio\" title=\"C\u1ed9ng h\u01a1n 24 gi\u1edd.\">C\u1ed9ng h\u01a1n 24 gi\u1edd.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_hon_60_phut\" title=\"C\u1ed9ng h\u01a1n 60 ph\u00fat.\">C\u1ed9ng h\u01a1n 60 ph\u00fat.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Cong_hon_60_giay\" title=\"C\u1ed9ng h\u01a1n 60 gi\u00e2y.\">C\u1ed9ng h\u01a1n 60 gi\u00e2y.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Tru_hon_24_gio\" title=\"Tr\u1eeb h\u01a1n 24 gi\u1edd\">Tr\u1eeb h\u01a1n 24 gi\u1edd<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Tru_hon_60_phut\" title=\"Tr\u1eeb h\u01a1n 60 ph\u00fat.\">Tr\u1eeb h\u01a1n 60 ph\u00fat.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/blog.hocexcel.online\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html#Tru_hon_60_giay\" title=\"Tr\u1eeb h\u01a1n 60 gi\u00e2y\">Tr\u1eeb h\u01a1n 60 gi\u00e2y<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tinh_chenh_lech_thoi_gian_trong_Excel\"><\/span><strong>C\u00e1ch t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Tru_thoi_gian\"><\/span><strong>C\u00f4ng th\u1ee9c 1. Tr\u1eeb th\u1eddi gian<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, th\u1eddi gian trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ec3 tr\u00f4ng gi\u1ed1ng th\u1eddi gian. V\u00ec ch\u00fang l\u00e0 s\u1ed1, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 c\u1ed9ng tr\u1eeb th\u1eddi gian nh\u01b0 c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian l\u00e0:<\/p>\n<p style=\"text-align: justify\"><strong><em>=End time \u2013 Start time<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">T\u00f9y v\u00e0o c\u1ea5u tr\u00fac d\u1eef li\u1ec7u, ch\u00eanh l\u1ec7ch th\u1eddi gian th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u d\u1ea1ng kh\u00e1c nhau, v\u00ed d\u1ee5:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"306\"><strong>C\u00f4ng th\u1ee9c<\/strong><\/td>\n<td width=\"456\"><strong>Gi\u1ea3i th\u00edch<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>=A2-B2<\/strong><\/td>\n<td>T\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch th\u1eddi gian gi\u1eefa hai gi\u00e1 tr\u1ecb trong \u00f4 A2 v\u00e0 B2<\/td>\n<\/tr>\n<tr>\n<td><strong>=TIMEVALUE(\u201c8:30 PM\u201d) \u2013 TIMEVALUE(\u201c6:40 AM\u201d)<\/strong><\/td>\n<td>T\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch th\u1eddi gian gi\u1eefa hai th\u1eddi gian c\u1ee5 th\u1ec3<\/td>\n<\/tr>\n<tr>\n<td><strong>=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) \u2013 TIME(HOUR(B2), MINUTE(B2), SECOND(B2))<\/strong><\/td>\n<td>T\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch th\u1eddi gian gi\u1eefa hai gi\u00e1 tr\u1ecb trong \u00f4 A2 v\u00e0 B2, kh\u00f4ng t\u00ednh ch\u00eanh l\u1ec7ch ng\u00e0y th\u00e1ng n\u1ebfu \u00f4 t\u00ednh ch\u1ee9a c\u1ea3 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Trong h\u1ec7 th\u1ed1ng Excel, th\u1eddi gian bi\u1ec3u th\u1ecb \u1edf ph\u1ea7n th\u1eadp ph\u00e2n, b\u1ea1n s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<figure id=\"attachment_6249\" aria-describedby=\"caption-attachment-6249\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6249 size-full\" title=\"1 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-165.png\" alt=\"1 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"600\" height=\"173\"><figcaption id=\"caption-attachment-6249\" class=\"wp-caption-text\">1 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ph\u1ea7n th\u1eadp ph\u00e2n trong c\u1ed9t D \u0111\u00fang nh\u01b0ng kh\u00f4ng c\u00f3 \u00fd ngh\u0129a. \u0110\u1ec3 gi\u00fap ch\u00fang cung c\u1ea5p th\u00f4ng tin c\u00f3 \u00edch h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian v\u1edbi m\u1ed9t trong c\u00e1c m\u00e3 sau \u0111\u00e2y:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"186\"><strong>M\u00e3 th\u1eddi gian<\/strong><\/td>\n<td width=\"228\"><strong>Gi\u1ea3i th\u00edch<\/strong><\/td>\n<\/tr>\n<tr>\n<td>h<\/td>\n<td>S\u1ed1 gi\u1edd tr\u00f4i qua, v\u00ed d\u1ee5 4<\/td>\n<\/tr>\n<tr>\n<td>h:mm<\/td>\n<td>S\u1ed1 gi\u1edd v\u00e0 s\u1ed1 ph\u00fat tr\u00f4i qua, v\u00ed d\u1ee5 4:10<\/td>\n<\/tr>\n<tr>\n<td>h:mm:ss<\/td>\n<td>S\u1ed1 gi\u1edd, s\u1ed1 ph\u00fat v\u00e0 s\u1ed1 gi\u00e2y tr\u00f4i qua, v\u00ed d\u1ee5 4:10:20.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian, nh\u1ea5n <strong><em>Ctrl + 1 <\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>, ch\u1ecdn <strong><em>Custom <\/em><\/strong>t\u1eeb <strong><em>Category list <\/em><\/strong>v\u00e0 g\u00f5 m\u00e3 th\u1eddi gian v\u00e0o h\u1ed9p <strong><em>Type<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, \u0111\u1ec3 xem c\u00f4ng th\u1ee9c t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian v\u00e0 m\u00e3 th\u1eddi gian ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o trong b\u1ea3ng t\u00ednh th\u1ef1c s\u1ef1. V\u1edbi Start time trong c\u1ed9t A v\u00e0 End time trong c\u1ed9t B, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t C v\u00e0 E:<\/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-59.gif\" title=\"vba101_92019-nho-59\"><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-142.gif\" title=\"ex101_92019-nho-142\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong><em>=$B2-$A2<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Th\u1eddi gian ch\u00eanh l\u1ec7ch \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb kh\u00e1c nhau t\u00f9y v\u00e0o \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong m\u1ed7i c\u1ed9t:<\/p>\n<figure style=\"width: 453px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"2 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-difference-hours-minutes-seconds.png\" alt=\"2 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"453\" height=\"141\"><figcaption class=\"wp-caption-text\">2 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong><em>. <\/em>N\u1ebfu th\u1eddi gian ch\u00eanh l\u1ec7ch \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb th\u00e0nh <strong><em>#####<\/em><\/strong>, ngh\u0129a l\u00e0 \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ebft th\u1eddi gian ho\u1eb7c k\u1ebft qu\u1ea3 ph\u00e9p t\u00ednh l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb \u00e2m.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: t\u00e0i li\u1ec7u\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">h\u1ecdc Excel c\u01a1 b\u1ea3n 2020<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Tinh_chenh_lech_thoi_gian_bang_ham_TEXT\"><\/span><strong>C\u00f4ng th\u1ee9c 2. T\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian b\u1eb1ng h\u00e0m TEXT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t k\u1ef9 thu\u1eadt kh\u00e1c \u0111\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian trong Excel l\u00e0 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m TEXT<\/a>\u00a0.<\/p>\n<ul style=\"text-align: justify\">\n<li>T\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch gi\u1edd gi\u1eefa hai th\u1eddi gian: <strong><em>=TEXT(B2-A2, \u201ch\u201d)<\/em><\/strong><\/li>\n<li>T\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch gi\u1edd v\u00e0 ph\u00fat gi\u1eefa hai th\u1eddi gian: <strong><em>=TEXT(B2-A2, \u201ch:mm\u201d)<\/em><\/strong><\/li>\n<li>T\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y gi\u1eefa hai th\u1eddi gian: <strong><em>=TEXT(B2-A2, \u201ch:mm:ss\u201d)<\/em><\/strong><\/li>\n<\/ul>\n<figure style=\"width: 615px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"3 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-difference-text-function.png\" alt=\"3 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"615\" height=\"139\"><figcaption class=\"wp-caption-text\">3 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m TEXT lu\u00f4n l\u00e0 v\u0103n b\u1ea3n. C\u00e1c gi\u00e1 tr\u1ecb text \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 tr\u00e0i trong c\u00e1c c\u1ed9t C, D, E trong h\u00ecnh tr\u00ean. Trong v\u00e0i t\u00ecnh hu\u1ed1ng nh\u1ea5t \u0111\u1ecbnh, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t h\u1ea1n ch\u1ebf v\u00ec b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 n\u00e0y \u0111\u1ec3 ti\u1ebfp t\u1ee5c t\u00ednh to\u00e1n.<\/li>\n<li>N\u1ebfu k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t s\u1ed1 \u00e2m, c\u00f4ng th\u1ee9c TEXT s\u1ebd hi\u1ec3n th\u1ecb <a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">l\u1ed7i <strong><em>#VALUE!<\/em><\/strong>.<\/a><\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_3_Tinh_gio_phut_giay_giua_hai_thoi_gian\"><\/span><strong>C\u00f4ng th\u1ee9c 3. T\u00ednh gi\u1edd, ph\u00fat, gi\u00e2y gi\u1eefa hai th\u1eddi gian<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3n th\u1ecb ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi gian b\u1eb1ng m\u1ed9t \u0111\u01a1n v\u1ecb (gi\u1edd, ph\u00fat, gi\u00e2y), b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh sau.<\/p>\n<p style=\"text-align: justify\"><strong>Ph\u00e9p t\u00ednh gi\u1edd gi\u1eefa hai th\u1eddi gian<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=(End time \u2013 Start time) * 24<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed th\u1eddi gian b\u1eaft \u0111\u1ea7u trong \u00f4 A2 v\u00e0 th\u1eddi gian k\u1ebft th\u00fac trong \u00f4 B2, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng ph\u00e9p t\u00ednh \u0111\u01a1n gi\u1ea3n l\u00e0 B2-A2 \u0111\u1ec3 t\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch th\u1eddi gian, sau \u0111\u00f3 nh\u00e2n v\u1edbi 24.<\/p>\n<p style=\"text-align: justify\"><strong><em>=(B2-A2) * 24<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 s\u1ed1 Complete hours, s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong><em>INT <\/em><\/strong><\/a>\u0111\u1ec3 l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean h\u1ea7n nh\u1ea5t:<\/p>\n<p style=\"text-align: justify\"><strong><em>=INT((B2-A2) * 24)<\/em><\/strong><\/p>\n<figure style=\"width: 442px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"4 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-difference-hours.png\" alt=\"4 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"442\" height=\"166\"><figcaption class=\"wp-caption-text\">4 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong><em>\u00a0<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>T\u1ed5ng s\u1ed1 ph\u00fat gi\u1eefa hai th\u1eddi gian:<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh s\u1ed1 ph\u00fat gi\u1eefa hai th\u1eddi gian, nh\u00e2n ch\u00eanh l\u1ec7ch th\u1eddi gian v\u1edbi 1440<\/p>\n<p style=\"text-align: justify\"><strong><em>=(End time \u2013 Start time) * 1440<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 cho k\u1ebft qu\u1ea3 \u00e2m ho\u1eb7c d\u01b0\u01a1ng, k\u1ebft qu\u1ea3 \u00e2m x\u1ea3y ra khi th\u1eddi gian k\u1ebft th\u00fac l\u1edbn h\u01a1n th\u1eddi gian b\u1eaft \u0111\u1ea7u nh\u01b0 h\u00e0ng 5:<\/p>\n<p style=\"text-align: justify\"><strong><em>=(B2-A2)*1440<\/em><\/strong><\/p>\n<figure style=\"width: 314px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"5 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-difference-minutes.png\" alt=\"5 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"314\" height=\"163\"><figcaption class=\"wp-caption-text\">5 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong><em>\u00a0<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>T\u1ed5ng s\u1ed1 gi\u00e2y gi\u1eefa hai th\u1eddi gian:<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh s\u1ed1 gi\u00e2y gi\u1eefa hai th\u1eddi gian, nh\u00e2n ch\u00eanh l\u1ec7ch th\u1eddi gian v\u1edbi 86400<\/p>\n<p style=\"text-align: justify\"><strong><em>=(End time \u2013 Start time) * 86400<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=(B2-A2)* 86400<\/em><\/strong><\/p>\n<figure style=\"width: 322px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"6 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-difference-seconds.png\" alt=\"6 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"322\" height=\"163\"><figcaption class=\"wp-caption-text\">6 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>\u0110\u1ecbnh d\u1ea1ng <strong><em>General <\/em><\/strong>n\u00ean \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp cho \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian \u0111\u1ec3 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb \u0111\u00fang.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_4_Tinh_chenh_lech_thoi_gian_trong_cung_mot_don_vi_thoi_gian_va_bo_qua_cac_don_vi_khac\"><\/span><strong>C\u00f4ng th\u1ee9c 4. T\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian trong c\u00f9ng m\u1ed9t \u0111\u01a1n v\u1ecb th\u1eddi gian v\u00e0 b\u1ecf qua c\u00e1c \u0111\u01a1n v\u1ecb kh\u00e1c\u00a0\u00a0 <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch gi\u1eefa hai th\u1eddi gian trong c\u00f9ng m\u1ed9t \u0111\u01a1n v\u1ecb, b\u1ecf qua c\u00e1c \u0111\u01a1n v\u1ecb th\u1eddi gian kh\u00e1c, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c h\u00e0m sau:<\/p>\n<p style=\"text-align: justify\">Ch\u00eanh l\u1ec7ch gi\u1edd, b\u1ecf qua ph\u00fat v\u00e0 gi\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=HOUR(B2-A2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u00eanh l\u1ec7ch ph\u00fat, b\u1ecf qua gi\u1edd v\u00e0 gi\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong><em>=MINUTE(B2-A2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u00eanh l\u1ec7ch gi\u00e2y, b\u1ecf qua gi\u1edd v\u00e0 ph\u00fat:<\/p>\n<p style=\"text-align: justify\"><strong><em>=SECOND(B2-A2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng h\u00e0m <strong><em>HOUR, MINUTE, SECOND<\/em><\/strong>, h\u00e3y nh\u1edb r\u1eb1ng k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u01b0\u1ee3c v\u01b0\u1ee3t qu\u00e1 24 gi\u1edd, 60 ph\u00fat ho\u1eb7c 60 gi\u00e2y.<\/p>\n<figure style=\"width: 514px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"7 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-difference-one-unit.png\" alt=\"7 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"514\" height=\"145\"><figcaption class=\"wp-caption-text\">7 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu th\u1eddi gian k\u1ebft th\u00fac l\u1edbn h\u01a1n th\u1eddi gian b\u1eaft \u0111\u1ea7u, c\u1ee5 th\u1ec3 n\u1ebfu k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 \u00e2m, c\u00f4ng th\u1ee9c s\u1ebd hi\u1ec3n th\u1ecb<a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"> l\u1ed7i <strong><em>#NUM!<\/em><\/strong><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_5_Tinh_thoi_gian_troi_qua_ke_tu_thoi_gian_bat_dau_den_bay_gio\"><\/span><strong>C\u00f4ng th\u1ee9c 5. T\u00ednh th\u1eddi gian tr\u00f4i qua k\u1ec3 t\u1eeb th\u1eddi gian b\u1eaft \u0111\u1ea7u \u0111\u1ebfn b\u00e2y gi\u1edd<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh th\u1eddi gian \u0111\u00e3 tr\u00f4i qua, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m Now v\u00e0 Time<\/a>. Tr\u01b0\u1eddng h\u1ee3p kho\u1ea3ng th\u1eddi gian tr\u00f4i qua d\u01b0\u1edbi\u00a024 gi\u1edd,\u00a0b\u1ea1n\u00a0ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m <strong><em>NOW<\/em><\/strong> \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i, sau \u0111\u00f3 tr\u1eeb \u0111i ng\u00e0y v\u00e0 th\u1eddi gian b\u1eaft \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed \u00f4 A2 ch\u1ee9a th\u1eddi \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u, c\u00f4ng th\u1ee9c <strong><em>=NOW()-A2 <\/em><\/strong>cho k\u1ebft qu\u1ea3 sau v\u1edbi c\u1ed9t B \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian ph\u00f9 h\u1ee3p, trong v\u00ed d\u1ee5 n\u00e0y n\u00f3 c\u00f3 d\u1ea1ng <strong><em>h:mm<\/em><\/strong><\/p>\n<figure style=\"width: 242px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"8 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-elapsed-time-excel.png\" alt=\"8 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"242\" height=\"182\"><figcaption class=\"wp-caption-text\">8 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong><em>\u00a0<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p kho\u1ea3ng th\u1eddi gian tr\u00f4i qua v\u01b0\u1ee3t qu\u00e1 24 gi\u1edd, s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian sau, v\u00ed d\u1ee5 d \u2018days\u2019 h:mm:ss nh\u01b0 trong h\u00ecnh sau:<\/p>\n<figure style=\"width: 268px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"9 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/elapsed-time-over-24-hours.png\" alt=\"9 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"268\" height=\"181\"><figcaption class=\"wp-caption-text\">9 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">N\u1ebfu th\u1eddi gian b\u1eaft \u0111\u1ea7u ch\u1ec9 c\u00f3 gi\u1edd ph\u00fat m\u00e0 kh\u00f4ng c\u00f3 ng\u00e0y, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m <strong>Time\u00a0<\/strong>\u0111\u1ec3 t\u00ednh to\u00e1n kho\u1ea3ng th\u1eddi gian tr\u00f4i \u0111i m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c sau tr\u1ea3 v\u1ec1 kho\u1ea3ng th\u1eddi gian t\u1eeb \u00f4 A2 \u0111\u1ebfn gi\u1edd.<\/p>\n<p style=\"text-align: justify\">=TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW())) \u2013 A2<\/p>\n<figure style=\"width: 280px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"10- c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-formula-elapsed-time.png\" alt=\"10- c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"280\" height=\"184\"><figcaption class=\"wp-caption-text\">10- c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>Kho\u1ea3ng th\u1eddi gian tr\u00f4i qua s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt theo th\u1eddi gian th\u1ef1c t\u1ebf, n\u00f3 ch\u1ec9 c\u1eadp nh\u1eadt khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c m\u1edf l\u1ea1i ho\u1eb7c t\u00ednh to\u00e1n l\u1ea1i. \u0110\u1ec3 c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c, nh\u1ea5n <strong><em>Shift + F9 <\/em><\/strong>\u0111\u1ec3 t\u00ednh l\u1ea1i trang t\u00ednh ho\u1eb7c nh\u1ea5n <strong><em>F9 <\/em><\/strong>\u0111\u1ec3 t\u00ednh l\u1ea1i to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_6_Hien_thi_chenh_lech_thoi_gian_%E2%80%9CXX_days_XX_hours_XX_minutes_and_XX_seconds%E2%80%9D\"><\/span><strong>C\u00f4ng th\u1ee9c 6. Hi\u1ec3n th\u1ecb ch\u00eanh l\u1ec7ch th\u1eddi gian \u201cXX days, XX hours, XX minutes and XX seconds\u201d<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/ham-thoi-gian-thong-dung-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong><em>HOUR, MINUTE <\/em><\/strong>v\u00e0 <strong><em>SECOND<\/em><\/strong><\/a> \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 th\u1eddi gian t\u01b0\u01a1ng t\u1ee9ng v\u00e0 h\u00e0m <strong><em>INT<\/em><\/strong> \u0111\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch ng\u00e0y.Sau \u0111\u00f3, b\u1ea1n l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m v\u00e0o c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c c\u00f9ng c\u00e1c chu\u1ed7i text nh\u01b0 sau\u00a0:<\/p>\n<p style=\"text-align: justify\"><strong><em>=INT(B2-A2) &amp; \u201d days, \u201d &amp; HOUR(B2-A2) &amp; \u201d hours, \u201d &amp; MINUTE(B2-A2) &amp; \u201d minutes and \u201d &amp; SECOND(B2-A2) &amp; \u201d seconds\u201d<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-difference-formula.png\" alt=\"A user-friendly Excel time difference formula\" title=\"excel-time-difference-formula\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u1ea9n gi\u00e1 tr\u1ecb 0, l\u1ed3ng b\u1ed1n <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong><em>IF <\/em><\/strong><\/a>v\u00e0o \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\"><strong><em>=IF(INT(B2-A2)&gt;0, INT(B2-A2) &amp; \u201d days, \u201c,\u201d\u201d) &amp; IF(HOUR(B2-A2)&gt;0, HOUR(B2-A2) &amp; \u201d hours, \u201c,\u201d\u201d) &amp; IF(MINUTE(B2-A2)&gt;0, MINUTE(B2-A2) &amp; \u201d minutes and \u201c,\u201d\u201d) &amp; IF(SECOND(B2-A2)&gt;0, SECOND(B2-A2) &amp; \u201d seconds\u201d,\u201d\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-difference-formula2.png\" alt=\"Excel time difference formula that ignores zero values\" title=\"excel-time-difference-formula2\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n ch\u00eanh l\u1ec7ch th\u1eddi gian b\u1eb1ng c\u00e1ch l\u1ea5y th\u1eddi gian b\u1eaft \u0111\u1ea7u tr\u1eeb th\u1eddi gian k\u1ebft th\u00fac (v\u00ed d\u1ee5 = B2-A2) r\u1ed3i thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng sau cho \u00f4 t\u00ednh:<\/p>\n<p style=\"text-align: justify\"><strong><em>d \u201cdays,\u201d h \u201chours,\u201d m \u201cminutes and\u201d s \u201cseconds\u201d <\/em><\/strong><\/p>\n<figure style=\"width: 546px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"11 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-time-format.png\" alt=\"11 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"546\" height=\"574\"><figcaption class=\"wp-caption-text\">11 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tinh_va_hien_thi_thoi_gian_am_trong_Excel\"><\/span><strong>C\u00e1ch t\u00ednh v\u00e0 hi\u1ec3n th\u1ecb th\u1eddi gian \u00e2m trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi t\u00ednh to\u00e1n ch\u00eanhh l\u1ec7ch th\u1edd gian, b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft g\u1eb7p l\u1ed7i <strong><em>##### <\/em><\/strong>v\u00ec \u0111\u1ed9 ch\u00eanh l\u1ec7ch n\u00e0y \u00e2m. Tuy nhi\u00ean, c\u0169ng c\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u00e2m trong Excel.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Phuong_phap_1_Thay_doi_he_thong_ngay_thang_cua_Excel_thanh_1904_date_system\"><\/span><strong>Ph\u01b0\u01a1ng ph\u00e1p 1. Thay \u0111\u1ed5i h\u1ec7 th\u00f4ng ng\u00e0y th\u00e1ng c\u1ee7a Excel th\u00e0nh 1904 date system<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u00e0o <strong><em>File &gt; Options &gt; Advanced<\/em><\/strong>, k\u00e9o thanh cu\u1ed1n xu\u1ed1ng <strong><em>When calculating this workbook <\/em><\/strong>v\u00e0 \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Use 1904 date system<\/em><\/strong>.<\/p>\n<figure style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"12 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1904-date-system.png\" alt=\"12 - c\u00e1ch t\u00ednh th\u1eddi gian trong Excel\" width=\"600\" height=\"327\"><figcaption class=\"wp-caption-text\">12 \u2013 c\u00e1ch t\u00ednh th\u1eddi gian trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Nh\u1ea5p OK \u0111\u1ec3 l\u01b0u c\u00e0i \u0111\u1eb7t m\u1edbi, gi\u00e1 tr\u1ecb \u00e2m s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/negative-times-excel.png\" alt=\"In the 1904 date system, negative times are displayed like negative numbers\" title=\"negative-times-excel\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Phuong_phap_2_Tinh_toan_thoi_gian_am_bang_cong_thuc\"><\/span><strong>Ph\u01b0\u01a1ng ph\u00e1p 2. T\u00ednh to\u00e1n th\u1eddi gian \u00e2m b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p 1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=IF(A2-B2&gt;0, A2-B2, \u201c-\u201d &amp; TEXT(ABS(A2-B2),\u201dh:mm\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=IF(A2-B2&gt;0, A2-B2, TEXT(ABS(A2-B2),\u201d-h:mm\u201d))<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u1ea3 hai c\u00f4ng th\u1ee9c s\u1ebd ki\u1ec3m tra ch\u00eanh l\u1ec7ch th\u1eddi gian (A2-B2) c\u00f3 l\u1edbn h\u01a1n 0 hay kh\u00f4ng v\u00e0 n\u00f3 c\u00f3 hi\u1ec7n k\u1ebft qu\u1ea3 hay kh\u00f4ng. N\u1ebfu ch\u00eanh l\u1ec7ch b\u00e9 h\u01a1n 0, c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean s\u1ebd t\u00ednh tr\u1ecb tuy\u1ec7t \u0111\u1ed1i r\u1ed3i th\u00eam d\u1ea5u tr\u1eeb. C\u00f4ng th\u1ee9c th\u1ee9 hai cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian \u00e2m \u201c-h:: mm\u201d.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calculate-negative-times-excel.png\" alt=\"A formula to calculate negative times in Excel\" title=\"calculate-negative-times-excel\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>H\u00e3y nh\u1edb r\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ea7u ti\u00ean cho ra k\u1ebft qu\u1ea3 \u00e2m l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 \u00e2m, k\u1ebft qu\u1ea3 h\u00e0m TEXT lu\u00f4n l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng trong ph\u00e9p to\u00e1n ho\u1eb7c c\u00f4ng th\u1ee9c kh\u00e1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Congtru_thoi_gian_trong_Excel\"><\/span><strong>C\u1ed9ng\/tr\u1eeb th\u1eddi gian trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1ec1 c\u01a1 b\u1ea3n, c\u00f3 2 c\u00e1ch c\u1ed9ng\/tr\u1eeb th\u1eddi gian trong Excel:<\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eed d\u1ee5ng h\u00e0m <strong><em>TIME<\/em><\/strong><\/li>\n<li>S\u1eed d\u1ee5ng ph\u00e9p to\u00e1n d\u1ef1a tr\u00ean s\u1ed1 gi\u1edd (24), s\u1ed1 ph\u00fat (1440), s\u1ed1 gi\u00e2y (86400) trong m\u1ed9t ng\u00e0y.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00e0m <strong><em>TIME(hour, minute, second) <\/em><\/strong>gi\u00fap vi\u1ec7c t\u00ednh to\u00e1n d\u1ec5 d\u00e0ng h\u01a1n, tuy nhi\u00ean n\u00f3 kh\u00f4ng cho ph\u00e9p vi\u1ec7c c\u1ed9ng tr\u1eeb h\u01a1n 23 gi\u1edd, 59 ph\u00fat ho\u1eb7c 59 gi\u00e2y. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c ph\u00e9p to\u00e1n d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Tham\u00a0 kh\u1ea3o ngay: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Gi\u00e1o tr\u00ecnh Excel 2020<\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Congtru_gio_vao_thoi_gian_cu_the\"><\/span><strong>C\u1ed9ng\/tr\u1eeb gi\u1edd v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong>H\u00e0m th\u1eddi gian \u0111\u1ec3 c\u1ed9ng th\u00eam d\u01b0\u1edbi 24 gi\u1edd<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=Start time + TIME(N hours, 0, 0)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, trong \u00f4 A2 l\u00e0 th\u1eddi gian b\u1eaft \u0111\u1ea7u, b\u1ea1n mu\u1ed1n th\u00eam 2 gi\u1edd v\u00e0o \u0111\u00f3, c\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/p>\n<p style=\"text-align: justify\"><strong><em>=A2 + TIME(2, 0, 0)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/time-function-add-hours.png\" alt=\"TIME function to add under 24 hours\" title=\"time-function-add-hours\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n th\u1eed c\u1ed9ng h\u01a1n 23 gi\u1edd b\u1eb1ng h\u00e0m <strong><em>TIME, <\/em><\/strong>s\u1ed1 gi\u1edd \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh s\u1ebd chia cho 24 v\u00e0 ph\u1ea7n nguy\u00ean s\u1ebd th\u00eam v\u00e0o th\u1eddi gian b\u1eaft \u0111\u1ea7u. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u1ed9ng th\u00eam 25 gi\u1edd v\u00e0o 6\/2\/20155 10:00 AM\u00a0(\u00f4 A4) b\u1eb1ng c\u00f4ng th\u1ee9c <strong><em>=A4 + TIME(25, 0, 0)<\/em><\/strong>, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0: 06\/02\/2015 11:00, c\u1ee5 th\u1ec3 l\u00e0 A4 + 1 gi\u1edd<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_de_cong_bat_ky_so_gio_nao_duoitren_24_gio\"><\/span><strong>C\u00f4ng th\u1ee9c \u0111\u1ec3 c\u1ed9ng b\u1ea5t k\u1ef3 s\u1ed1 gi\u1edd n\u00e0o (d\u01b0\u1edbi\/tr\u00ean 24 gi\u1edd)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c sau kh\u00f4ng c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 s\u1ed1 gi\u1edd b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam:<\/p>\n<p style=\"text-align: justify\"><strong><em>=Start time + (N hours\/24)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 c\u1ed9ng th\u00eam 28 gi\u1edd v\u00e0o \u00f4 A2, nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=A2 + (28\/24)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-hours-excel.png\" alt=\"Universal formula to add hours to a given time in Excel\" title=\"add-hours-excel\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb \u0111i m\u1ed9t s\u1ed1 gi\u1edd, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 thay d\u1ea5u + b\u1eb1ng d\u1ea5u \u2013<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, tr\u1eeb \u00f4 A2 cho 3 gi\u1edd, nh\u1eadp m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=A2-(3\/24)<\/em><\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=A2-TIME(3,0,0)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n tr\u1eeb s\u1ed1 gi\u1edd l\u1edbn h\u01a1n 23, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_congtru_phut_vao_thoi_gian_cu_the\"><\/span><strong>C\u00e1ch c\u1ed9ng\/tr\u1eeb ph\u00fat v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong>C\u1ed9ng\/tr\u1eeb d\u01b0\u1edbi 60 ph\u00fat<\/strong><\/p>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m <strong><em>TIME <\/em><\/strong>\u0111\u1ec3 c\u1ed9ng tr\u1eeb s\u1ed1 ph\u00fat b\u1ea1n mu\u1ed1n v\u00e0o tham s\u1ed1 th\u1ee9 2:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=Start time + TIME(0, N minutes, 0)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c th\u1ef1c t\u1ebf \u0111\u1ec3 t\u00ednh s\u1ed1 ph\u00fat trong Excel:<\/p>\n<p style=\"text-align: justify\">C\u00f4ng 20 ph\u00fat v\u00e0o A2: <strong><em>=A2 + TIME(0,20,0)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tr\u1eeb A2 cho 30 ph\u00fat: <strong><em>=A2 \u2013 TIME(0,30,0)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>C\u1ed9ng tr\u1eeb tr\u00ean 60 ph\u00fat<\/strong><\/p>\n<p style=\"text-align: justify\">Trong ph\u00e9p t\u00ednh c\u1ee7a b\u1ea1n, chia s\u1ed1 ph\u00fat cho 1440 \u2013 s\u1ed1 ph\u00fat trong m\u1ed9t ng\u00e0y v\u00e0 th\u00eam th\u1eddi gian b\u1eaft \u0111\u1ea7u v\u00e0o\u00a0:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=Start time + (N minutes \/ 1440)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb s\u1ed1 ph\u00fat, thay d\u1ea5u + th\u00e0nh d\u1ea5u -. V\u00ed d\u1ee5\u00a0:<\/p>\n<p style=\"text-align: justify\">C\u1ed9ng th\u00eam 200 ph\u00fat: <strong><em>=A2 + (200\/1440)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tr\u1eeb \u0111i 300 ph\u00fat: <strong><em>=A2 -(300\/1440)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6250\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-166.png\" width=\"600\" height=\"134\" title=\"excel-dialog-box-launcher-1-166\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_congtru_giay_vao_thoi_gian_cu_the\"><\/span><strong>C\u00e1ch c\u1ed9ng\/tr\u1eeb gi\u00e2y v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u1ed9ng th\u00eam s\u1ed1 gi\u00e2y \u00edt h\u01a1n 60 v\u00e0o th\u1eddi gian c\u1ee5 th\u1ec3, s\u1eed d\u1ee5ng h\u00e0m <strong><em>TIME<\/em><\/strong>:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=Start time + TIME(0, 0, N seconds)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u1ed9ng th\u00eam s\u1ed1 gi\u00e2y l\u1edbn h\u01a1n 59, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=Start time + (N seconds \/ 86400)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1eeb s\u1ed1 gi\u00e2y, t\u1eadn d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng thay d\u1ea5u + th\u00e0nh d\u1ea5u -.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean trang t\u00ednh Excel, c\u00f4ng th\u1ee9c tr\u00f4ng nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"text-align: justify\">Th\u00eam 30 gi\u00e2y v\u00e0o \u00f4 A2:<strong><em> =A2 + TIME(0,0,31)<\/em><\/strong><\/li>\n<li style=\"text-align: justify\">Th\u00eam 1200 gi\u00e2y v\u00e0o \u00f4 A2: <strong><em>=A2 + (1200\/86400)<\/em><\/strong><\/li>\n<li style=\"text-align: justify\">Tr\u1eeb \u00f4 A2 cho 40 gi\u00e2y: <strong><em>=A2 \u2013 TIME(0,0,40)<\/em><\/strong><\/li>\n<li style=\"text-align: justify\">Tr\u1eeb \u00f4 A2 cho 900 gi\u00e2y: <strong><em>=A2 \u2013 (900\/86400)<\/em><\/strong><\/li>\n<\/ul>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_cong_thoi_gian_trong_Excel\"><\/span><strong>C\u00e1ch c\u1ed9ng th\u1eddi gian trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Ph\u00e9p c\u1ed9ng Excel th\u01b0\u1eddng s\u1eed d\u1ee5ng h\u00e0m <strong><em>SUM<\/em><\/strong>, v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p cho k\u1ebft qu\u1ea3.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t v\u00e0i th\u1eddi gian trong c\u1ed9t B v\u00e0 b\u1ea1n mu\u1ed1n c\u1ed9ng ch\u00fang v\u1edbi nhau. B\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c <strong><em>SUM <\/em><\/strong>nh\u01b0 sau\u00a0<strong><em>=SUM(B2:B4)<\/em><\/strong>, k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb theo \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh nh\u01b0 <strong><em>hh:mm:ss<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sum-time.png\" alt=\"A SUM formula to add up times in Excel\" title=\"excel-sum-time\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong m\u1ed9t v\u00e0i tr\u01b0\u1eddng h\u1ee3p, \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh c\u00f3 th\u1ec3 \u1ed5n, nh\u01b0ng \u0111\u00f4i khi b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb t\u1ed5ng th\u1eddi gian d\u01b0\u1edbi d\u1ea1ng ph\u00fat v\u00e0 gi\u00e2y, ho\u1eb7c ch\u1ec9 hi\u1ec3n th\u1ecb gi\u00e2y. Khi \u0111\u00f3, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u00e9p t\u00ednh n\u00e0o c\u1ea3, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i th\u1eddi gian cho \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c <strong><em>SUM<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p ph\u1ea3i v\u00e0o \u00f4 t\u00ednh v\u00e0 ch\u1ecdn <strong><em>Format Cells<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, nh\u1ea5n <strong><em>Ctrl + 1 <\/em><\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>. Ch\u1ecdn <strong><em>Custom <\/em><\/strong>t\u1eeb <strong><em>Category list <\/em><\/strong>v\u00e0 g\u00f5 m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng sau v\u00e0o h\u1ed9p <strong><em>Type<\/em><\/strong>:<\/p>\n<p style=\"text-align: justify\">Hi\u1ec3n th\u1ecb th\u1eddi gian d\u01b0\u1edbi d\u1ea1ng ph\u00fat v\u00e0 gi\u00e2y: <strong><em>[m]:ss<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Hi\u1ec3n th\u1ecb th\u1eddi gian d\u01b0\u1edbi d\u1ea1ng gi\u00e2y: <strong><em>[ss]<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sum-minutes-seconds.png\" alt=\"Apply the custom time format to display total time as minutes and seconds, or seconds only.\" title=\"excel-sum-minutes-seconds\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch c\u1ed9ng qua 24 gi\u1edd trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh to\u00e1n k\u1ebft qu\u1ea3 h\u01a1n 24 gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>SUM<\/em><\/strong>, v\u00e0 ch\u1ecdn m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng sau:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"216\"><strong>\u0110\u1ecbnh d\u1ea1ng<\/strong><\/td>\n<td width=\"168\"><strong>Hi\u1ec3n th\u1ecb<\/strong><\/td>\n<td width=\"198\"><strong>Gi\u1ea3i th\u00edch<\/strong><\/td>\n<\/tr>\n<tr>\n<td>[h]:mm<\/td>\n<td>30:10<\/td>\n<td>Gi\u1edd v\u00e0 ph\u00fat<\/td>\n<\/tr>\n<tr>\n<td>[h]:mm:ss<\/td>\n<td>30:10:20<\/td>\n<td rowspan=\"2\">Gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<\/tr>\n<tr>\n<td>[h] \u201chours\u201d, mm \u201cminutes\u201d, ss \u201cseconds\u201d<\/td>\n<td>30 hours, 10 minutes, 20 seconds<\/td>\n<\/tr>\n<tr>\n<td>d h:mm:ss<\/td>\n<td>1 06:10:20<\/td>\n<td rowspan=\"3\">Ng\u00e0y, gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<\/tr>\n<tr>\n<td>d \u201cday\u201d h:mm:ss<\/td>\n<td>1 day 06:10:20<\/td>\n<\/tr>\n<tr>\n<td>d \u201cday,\u201d h \u201chours,\u201d m \u201cminutes and\u201d s \u201cseconds\u201d<\/td>\n<td>1 day, 6 hours, 10 minutes and 20 seconds<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">\u0110\u1ec3 xem k\u1ebft qu\u1ea3 \u0111\u1ecbnh d\u1ea1ng trong trang t\u00ednh th\u1ef1c, xem h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y (c\u00f4ng th\u1ee9c <strong><em>SUM <\/em><\/strong>\u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 A9 t\u1edbi \u00f4 A13:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong><em>=SUM($B$2:$B$4)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> \u0110\u1ecbnh d\u1ea1ng th\u1eddi gian ch\u1ec9 \u00e1p d\u1ee5ng cho s\u1ed1 d\u01b0\u01a1ng. N\u1ebfu k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n l\u00e0 s\u1ed1 \u00e2m, ngh\u0129a l\u00e0 b\u1ea1n l\u1ea5y gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n tr\u1eeb cho gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb <strong><em>#####<\/em><\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sum-time-over-24hours.png\" alt=\"Adding up more than 24 hours in Excel\" title=\"excel-sum-time-over-24hours\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_hien_thi_khoang_thoi_gian_lon_hon_24_gio_60_phut_60_giay\"><\/span>C\u00e1ch hi\u1ec3n th\u1ecb kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 hi\u1ec7n th\u1ecb m\u1ed9t kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y, h\u00e3y s\u1eed d\u1ee5ng\u00a0<strong><em>custom time format<\/em><\/strong>\u00a0n\u01a1i m\u00e0 m\u00e3 \u0111\u01a1n v\u1ecb th\u1eddi gian t\u01b0\u01a1ng \u1ee9ng n\u1eb1m trong d\u1ea5u ngo\u1eb7c vu\u00f4ng, ch\u1eb3ng h\u1ea1n nh\u01b0\u00a0<strong>[h], [m], hay [s]<\/strong>. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc h\u01b0\u1edbng d\u1eabn chi ti\u1ebft:<\/p>\n<ol>\n<li>Ch\u1ecdn m\u1ed9t hay \u00a0nhi\u1ec1u \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn r\u1ed3i l\u1ea1i nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0<strong><em>Format Cells<\/em><\/strong>, hay b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n\u00a0<em><strong>Ctrl + 1,\u00a0<\/strong><\/em>thao t\u00e1c n\u00e0y s\u1ebd gi\u00fap m\u1edf h\u1ed9p tho\u1ea1i\u00a0<strong><em>Format Cells<\/em><\/strong>.<\/li>\n<li>Trong\u00a0<strong><em>Number tab<\/em><\/strong>, b\u00ean d\u01b0\u1edbi\u00a0<strong><em>Category<\/em><\/strong>, h\u00e3y ch\u1ecdn\u00a0<em><strong>Custom<\/strong><\/em>\u00a0r\u1ed3i g\u00f5 m\u1ed9t trong nh\u1eefng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian d\u01b0\u1edbi \u0111\u00e2y trong h\u1ed9p Type:<\/li>\n<\/ol>\n<p>L\u1edbn h\u01a1n 24 gi\u1edd: [h]:mm:ss hay [h]:mm<\/p>\n<p>L\u1edbn h\u01a1n 60 ph\u00fat: [m]:ss<\/p>\n<p>L\u1edbn h\u01a1n 60 gi\u00e2y: [s]<\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian \u201cl\u1edbn h\u01a1n 24 gi\u1edd\u201d tr\u00ean th\u1ef1c t\u1ebf:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5691 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/41-1.png\" width=\"541\" height=\"676\" title=\"41-1\"><\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i \u0111\u1ecbnh d\u1ea1ng kh\u00e1c. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 hi\u1ec3n th\u1ecb nh\u1eefng kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n chi\u1ec1u d\u00e0i \u0111\u01a1n v\u1ecb th\u1eddi gian chu\u1ea9n.<\/p>\n<table>\n<tbody>\n<tr>\n<td>Mi\u00eau t\u1ea3<\/td>\n<td>M\u00e3 \u0111\u1ecbnh d\u1ea1ng<\/td>\n<\/tr>\n<tr>\n<td>T\u1ed5ng s\u1ed1 gi\u1edd<\/td>\n<td>[h]<\/td>\n<\/tr>\n<tr>\n<td>S\u1ed1 gi\u1edd v\u00e0 ph\u00fat<\/td>\n<td>[h]:mm<\/td>\n<\/tr>\n<tr>\n<td>S\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y<\/td>\n<td>[h]:mm:ss<\/td>\n<\/tr>\n<tr>\n<td>T\u1ed5ng s\u1ed1 ph\u00fat<\/td>\n<td>[m]<\/td>\n<\/tr>\n<tr>\n<td>S\u1ed1 ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<td>[m]:ss<\/td>\n<\/tr>\n<tr>\n<td>T\u1ed5ng s\u1ed1 gi\u00e2y<\/td>\n<td>[s]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho d\u1eef li\u1ec7u m\u1eabu c\u1ee7a ch\u00fang ta (Th\u1eddi gian t\u1ed5ng c\u1ed9ng 50:40 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean), nh\u1eefng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian n\u00e0y s\u1ebd cho k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td>A<\/td>\n<td>B<\/td>\n<td>C<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Mi\u00eau t\u1ea3<\/td>\n<td>Th\u1eddi gian hi\u1ec3n th\u1ecb<\/td>\n<td>\u0110\u1ecbnh d\u1ea1ng<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>S\u1ed1 gi\u1edd<\/td>\n<td>50<\/td>\n<td>[h]<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>S\u1ed1 gi\u1edd v\u00e0 ph\u00fat<\/td>\n<td>50:40<\/td>\n<td>[h]:mm<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>S\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y<\/td>\n<td>50:40:30<\/td>\n<td>[h]:mm:ss<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>S\u1ed1 ph\u00fat<\/td>\n<td>3040<\/td>\n<td>[m]<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>S\u1ed1ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<td>3040:30<\/td>\n<td>[m]:ss<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>S\u1ed1 gi\u00e2y<\/td>\n<td>182430<\/td>\n<td>[s]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0110\u1ec3 nh\u1eefng kho\u1ea3ng th\u1eddi gian \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf tr\u00ean d\u1ec5 hi\u1ec3u h\u01a1n \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 b\u1ed5 sung \u0111\u01a1n v\u1ecb th\u1eddi gian b\u1eb1ng c\u00e1c t\u1eeb vi\u1ebft t\u1eaft t\u01b0\u01a1ng \u1ee9ng, v\u00ed d\u1ee5:<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td>A<\/td>\n<td>B<\/td>\n<td>C<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Mi\u00eau t\u1ea3<\/td>\n<td>Th\u1eddi gian hi\u1ec3n th\u1ecb<\/td>\n<td>\u0110\u1ecbnh d\u1ea1ng<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>S\u1ed1 gi\u1edd v\u00e0 ph\u00fat<\/td>\n<td>50 gi\u1edd v\u00e0 40 ph\u00fat<\/td>\n<td>[h] \u201cs\u1ed1 gi\u1edd v\u00e0\u201d mm \u201cs\u1ed1 ph\u00fat\u201d<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>S\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y<\/td>\n<td>50h.40m.30s<\/td>\n<td>[h] \u201ch.\u201d mm \u201cm.\u201d ss \u201cs.\u201d<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>S\u1ed1 ph\u00fat<\/td>\n<td>3040 ph\u00fat<\/td>\n<td>[m] \u201cs\u1ed1 ph\u00fat\u201d<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>S\u1ed1 ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<td>3040 ph\u00fat v\u00e0 30 gi\u00e2y<\/td>\n<td>[m] \u201cs\u1ed1 ph\u00fat v\u00e0\u201d ss \u201cs\u1ed1 gi\u00e2y\u201d<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>S\u1ed1 gi\u00e2y<\/td>\n<td>182430 gi\u00e2y<\/td>\n<td>[s] \u201cs\u1ed1 gi\u00e2y\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>L\u01b0u \u00fd.<\/strong>\u00a0M\u1eb7c d\u00f9 nh\u1eefng kho\u1ea3ng th\u1eddi gian tr\u00ean tr\u00f4ng gi\u1ed1ng nh\u01b0 chu\u1ed7i k\u00fd t\u1ef1, nh\u01b0ng ch\u00fang v\u1eabn l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1, b\u1edfi v\u00ec \u0111\u1ecbnh d\u1ea1ng ch\u1eef s\u1ed1 trong Excel ch\u1ec9 thay \u0111\u1ed5i v\u1ec1 h\u00ecnh th\u1ee9c ch\u1ee9 b\u1ea3n ch\u1ea5t kh\u00f4ng thay \u0111\u1ed5i. V\u00ec th\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do c\u1ed9ng hay tr\u1eeb nh\u1eefng kho\u1ea3ng th\u1eddi gian \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng, h\u00e3y tham chi\u1ebfu ch\u00fang trong c\u00f4ng th\u1ee9c v\u00e0 s\u1eed d\u1ee5ng trong c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_cong_tru_thoi_gian_lon_hon_24_gio_60_phut_60_giay\"><\/span>C\u00e1ch c\u1ed9ng tr\u1eeb th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u1ed9ng kho\u1ea3ng th\u1eddi gian mong mu\u1ed1n cho m\u1ed9t kho\u1ea3ng th\u1eddi gian cho s\u1eb5n, h\u00e3y l\u1ea5y s\u1ed1 gi\u1edd, ph\u00fat, hay gi\u00e2y m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed9ng cho \u0111\u01a1n v\u1ecb th\u1eddi gian t\u01b0\u01a1ng \u1ee9ng trong m\u1ed9t ng\u00e0y (24 gi\u1edd, 1440 ph\u00fat, 86400 gi\u00e2y), r\u1ed3i c\u1ed9ng s\u1ed1 th\u01b0\u01a1ng cho th\u1eddi gian b\u1eaft \u0111\u1ea7u.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_hon_24_gio\"><\/span><span id=\"Cong_hon_24_gio\" class=\"ez-toc-section\"><\/span>C\u1ed9ng h\u01a1n 24 gi\u1edd.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Th\u1eddi gian b\u1eaft \u0111\u1ea7u + (N\/24)<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_hon_60_phut\"><\/span><span id=\"Cong_hon_60_phut\" class=\"ez-toc-section\"><\/span>C\u1ed9ng h\u01a1n 60 ph\u00fat.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Th\u1eddi gian b\u1eaft \u0111\u1ea7u + (N\/1440)<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_hon_60_giay\"><\/span><span id=\"Cong_hon_60_giay\" class=\"ez-toc-section\"><\/span>C\u1ed9ng h\u01a1n 60 gi\u00e2y.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Th\u1eddi gian b\u1eaft \u0111\u1ea7u + (N\/86400)<\/p>\n<p>Trong \u0111\u00f3, N l\u00e0 s\u1ed1 gi\u1edd, ph\u00fat, hay gi\u00e2y m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed9ng.<\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c tr\u00ean th\u1ef1c t\u1ebf:<\/p>\n<p>\u0110\u1ec3 c\u1ed9ng 45 gi\u1edd cho th\u1eddi gian b\u1eaft \u0111\u1ea7u trong \u00f4 A2:<\/p>\n<p>=A2+(45\/24)<\/p>\n<p>\u0110\u1ec3 c\u1ed9ng 100 ph\u00fat cho th\u1eddi gian b\u1eaft \u0111\u1ea7u trong \u00f4 A2:<\/p>\n<p>=A2+(100\/1440)<\/p>\n<p>\u0110\u1ec3 c\u1ed9ng 200 gi\u00e2y cho th\u1eddi gian b\u1eaft \u0111\u1ea7u trong \u00f4 A2:<\/p>\n<p>=A2+(200\/86400)<\/p>\n<p>Hay l\u00e0, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp kho\u1ea3ng th\u1eddi gian c\u1ea7n c\u1ed9ng v\u00e0o m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t r\u1ed3i tham chi\u1ebfu \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5693 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/43-1.png\" width=\"591\" height=\"165\" title=\"43-1\"><\/p>\n<p>\u0110\u1ec3 tr\u1eeb kho\u1ea3ng th\u1eddi gian trong Excel, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng h\u00e3y thay d\u1ea5u c\u1ed9ng b\u1eb1ng d\u1ea5u tr\u1eeb nh\u00e9!<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tru_hon_24_gio\"><\/span><span id=\"Tru_hon_24_gio\" class=\"ez-toc-section\"><\/span>Tr\u1eeb h\u01a1n 24 gi\u1edd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Th\u1eddi gian b\u1eaft \u0111\u1ea7u \u2013 (N\/24)<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tru_hon_60_phut\"><\/span><span id=\"Tru_hon_60_phut\" class=\"ez-toc-section\"><\/span>Tr\u1eeb h\u01a1n 60 ph\u00fat.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Th\u1eddi gian b\u1eaft \u0111\u1ea7u \u2013 (N\/1440)<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tru_hon_60_giay\"><\/span><span id=\"Tru_hon_60_giay\" class=\"ez-toc-section\"><\/span>Tr\u1eeb h\u01a1n 60 gi\u00e2y<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Th\u1eddi gian b\u1eaft \u0111\u1ea7u \u2013 (N\/86400)<\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y hi\u1ec3n th\u1ecb c\u00e1c k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5694 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/44-1.png\" width=\"577\" height=\"163\" title=\"44-1\"><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ol>\n<li>N\u1ebfu kho\u1ea3ng th\u1eddi gian \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n c\u00f3 d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n, h\u00e3y s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian\/ng\u00e0y \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u00f4.<\/li>\n<li>N\u1ebfu sau khi s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng v\u00e0 \u00f4 hi\u1ec3n th\u1ecb #####, th\u00ec th\u00f4ng th\u01b0\u1eddng \u00f4 kh\u00f4ng \u0111\u1ee7 r\u1ed9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb th\u1eddi gian trong ng\u00e0y. \u0110\u1ec3 x\u1eed l\u00fd \u0111i\u1ec1u n\u00e0y, h\u00e3y m\u1edf r\u1ed9ng chi\u1ec1u d\u00e0i \u00f4 b\u1eb1ng c\u00e1ch nh\u1ea5p \u0111\u00fap chu\u1ed9t hay k\u00e9o khung b\u00ean ph\u1ea3i c\u1ee7a c\u1ed9t.<\/li>\n<\/ol>\n<h2><\/h2>\n<p>\u0110\u00f3 l\u00e0 to\u00e0n b\u1ed9 c\u00e1ch \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 <strong>c\u00e1ch c\u1ed9ng tr\u1eeb th\u1eddi gian trong excel<\/strong>. N\u1ebfu c\u00f2n b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc g\u00ec th\u00ec \u0111\u1eebng ng\u1ea1i ng\u1ea7n cmt xu\u1ed1ng d\u01b0\u1edbi \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p nhanh nh\u1ea5t nh\u00e9!<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/a><\/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-59.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1926,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1925","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\/1925","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=1925"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1925\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1926"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}