{"id":1251,"date":"2024-12-02T04:32:59","date_gmt":"2024-12-02T04:32:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-the-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel\/"},"modified":"2024-12-02T04:32:59","modified_gmt":"2024-12-02T04:32:59","slug":"lam-the-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/lam-the-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed9ng tr\u1eeb kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y<strong> <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc\u00a0Excel Online<\/a>\u00a0s<\/strong>\u1ebd cung c\u1ea5p m\u1ed9t v\u00e0i m\u1eb9o t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb nh\u1eefng kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y.<\/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-674d387a8ce9b\" 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\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.html#Lam_the_nao_de_hien_thi_khoang_thoi_gian_lon_hon_24_gio_60_phut_60_giay\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 hi\u1ec3n th\u1ecb kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 hi\u1ec3n th\u1ecb kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n 24 gi\u1edd, 60 ph\u00fat, 60 gi\u00e2y?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.html#Tinh_toan_su_chech_lech_thoi_gian_theo_gio_phut_giay\" title=\"T\u00ednh to\u00e1n s\u1ef1 ch\u00each l\u1ec7ch th\u1eddi gian theo gi\u1edd, ph\u00fat, gi\u00e2y\">T\u00ednh to\u00e1n s\u1ef1 ch\u00each l\u1ec7ch th\u1eddi gian theo gi\u1edd, ph\u00fat, gi\u00e2y<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.html#Su_chenh_lech_thoi_gian_theo_gio\" title=\"S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo gi\u1edd\">S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo gi\u1edd<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.html#Su_chenh_lech_thoi_gian_theo_phut\" title=\"S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo ph\u00fat\">S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo ph\u00fat<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.html#Su_chenh_lech_thoi_gian_theo_giay\" title=\"S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo gi\u00e2y\">S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo gi\u00e2y<\/a><\/li>\n<\/ul>\n<\/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\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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-7\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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-8\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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-9\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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-10\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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-11\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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-12\" href=\"https:\/\/blog.hocexcel.online\/lam-nao-de-cong-tru-khoang-thoi-gian-lon-hon-24-gio-60-phut-60-giay-trong-excel.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<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_hien_thi_khoang_thoi_gian_lon_hon_24_gio_60_phut_60_giay\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 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 <strong><em>custom time format<\/em><\/strong> n\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 <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 <strong><em>Format Cells<\/em><\/strong>, hay b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n <em><strong>Ctrl + 1, <\/strong><\/em>thao t\u00e1c n\u00e0y s\u1ebd gi\u00fap m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>.<\/li>\n<li>Trong <strong><em>Number tab<\/em><\/strong>, b\u00ean d\u01b0\u1edbi <strong><em>Category<\/em><\/strong>, h\u00e3y ch\u1ecdn <em><strong>Custom<\/strong><\/em> r\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.png\" width=\"541\" height=\"676\" title=\"41\"><\/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-88.gif\" title=\"ex101_92019-nho-88\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Xem th\u00eam: <strong>C\u00e1ch <\/strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-thoi-gian-trong-excel-chenh-lech-thoi-gian-cong-tru-thoi-gian.html\"><strong>C\u1ed9ng tr\u1eeb th\u1eddi gian trong Excel<\/strong><\/a><\/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 style=\"width: 381px;height: 219px\">\n<tbody>\n<tr>\n<td style=\"width: 166.953125px\">Mi\u00eau t\u1ea3<\/td>\n<td style=\"width: 198.0625px\">M\u00e3 \u0111\u1ecbnh d\u1ea1ng<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 166.953125px\">T\u1ed5ng s\u1ed1 gi\u1edd<\/td>\n<td style=\"width: 198.0625px\">[h]<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 166.953125px\">S\u1ed1 gi\u1edd v\u00e0 ph\u00fat<\/td>\n<td style=\"width: 198.0625px\">[h]:mm<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 166.953125px\">S\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y<\/td>\n<td style=\"width: 198.0625px;text-align: left\">[h]:mm:ss<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 166.953125px\">T\u1ed5ng s\u1ed1 ph\u00fat<\/td>\n<td style=\"width: 198.0625px\">[m]<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 166.953125px\">S\u1ed1 ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<td style=\"width: 198.0625px\">[m]:ss<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 166.953125px\">T\u1ed5ng s\u1ed1 gi\u00e2y<\/td>\n<td style=\"width: 198.0625px;text-align: left\">[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 style=\"height: 203px;width: 667px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 62px;height: 24px\"><\/td>\n<td style=\"width: 184px;height: 24px\">A<\/td>\n<td style=\"width: 212px;height: 24px\">B<\/td>\n<td style=\"width: 193px;height: 24px\">C<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 62px;height: 24px\">1<\/td>\n<td style=\"width: 184px;height: 24px\">Mi\u00eau t\u1ea3<\/td>\n<td style=\"width: 212px;height: 24px\">Th\u1eddi gian hi\u1ec3n th\u1ecb<\/td>\n<td style=\"width: 193px;height: 24px\">\u0110\u1ecbnh d\u1ea1ng<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 62px;height: 24px\">2<\/td>\n<td style=\"width: 184px;height: 24px\">S\u1ed1 gi\u1edd<\/td>\n<td style=\"width: 212px;height: 24px\">50<\/td>\n<td style=\"width: 193px;height: 24px\">[h]<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 62px;height: 24px\">3<\/td>\n<td style=\"width: 184px;height: 24px\">S\u1ed1 gi\u1edd v\u00e0 ph\u00fat<\/td>\n<td style=\"width: 212px;height: 24px\">50:40<\/td>\n<td style=\"width: 193px;height: 24px\">[h]:mm<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 62px;height: 24px\">4<\/td>\n<td style=\"width: 184px;height: 24px\">S\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y<\/td>\n<td style=\"width: 212px;height: 24px\">50:40:30<\/td>\n<td style=\"width: 193px;height: 24px\">[h]:mm:ss<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 62px;height: 24px\">5<\/td>\n<td style=\"width: 184px;height: 24px\">S\u1ed1 ph\u00fat<\/td>\n<td style=\"width: 212px;height: 24px\">3040<\/td>\n<td style=\"width: 193px;height: 24px\">[m]<\/td>\n<\/tr>\n<tr style=\"height: 24.875px\">\n<td style=\"width: 62px;height: 24.875px\">6<\/td>\n<td style=\"width: 184px;height: 24.875px\">S\u1ed1ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<td style=\"width: 212px;height: 24.875px\">3040:30<\/td>\n<td style=\"width: 193px;height: 24.875px\">[m]:ss<\/td>\n<\/tr>\n<tr style=\"height: 24.875px\">\n<td style=\"width: 62px;height: 24.875px\">7<\/td>\n<td style=\"width: 184px;height: 24.875px\">S\u1ed1 gi\u00e2y<\/td>\n<td style=\"width: 212px;height: 24.875px\">182430<\/td>\n<td style=\"width: 193px;height: 24.875px\">[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 style=\"height: 131px;width: 696px\">\n<tbody>\n<tr>\n<td style=\"width: 59px\"><\/td>\n<td style=\"width: 185px\">A<\/td>\n<td style=\"width: 197px\">B<\/td>\n<td style=\"width: 235px\">C<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 59px\">1<\/td>\n<td style=\"width: 185px\">Mi\u00eau t\u1ea3<\/td>\n<td style=\"width: 197px\">Th\u1eddi gian hi\u1ec3n th\u1ecb<\/td>\n<td style=\"width: 235px\">\u0110\u1ecbnh d\u1ea1ng<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 59px\">2<\/td>\n<td style=\"width: 185px\">S\u1ed1 gi\u1edd v\u00e0 ph\u00fat<\/td>\n<td style=\"width: 197px\">50 gi\u1edd v\u00e0 40 ph\u00fat<\/td>\n<td style=\"width: 235px\">[h] \u201cs\u1ed1 gi\u1edd v\u00e0\u201d mm \u201cs\u1ed1 ph\u00fat\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 59px\">3<\/td>\n<td style=\"width: 185px\">S\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y<\/td>\n<td style=\"width: 197px\">50h.40m.30s<\/td>\n<td style=\"width: 235px\">[h] \u201ch.\u201d mm \u201cm.\u201d ss \u201cs.\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 59px\">4<\/td>\n<td style=\"width: 185px\">S\u1ed1 ph\u00fat<\/td>\n<td style=\"width: 197px\">3040 ph\u00fat<\/td>\n<td style=\"width: 235px\">[m] \u201cs\u1ed1 ph\u00fat\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 59px\">5<\/td>\n<td style=\"width: 185px\">S\u1ed1 ph\u00fat v\u00e0 gi\u00e2y<\/td>\n<td style=\"width: 197px\">3040 ph\u00fat v\u00e0 30 gi\u00e2y<\/td>\n<td style=\"width: 235px\">[m] \u201cs\u1ed1 ph\u00fat v\u00e0\u201d ss \u201cs\u1ed1 gi\u00e2y\u201d<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 59px\">6<\/td>\n<td style=\"width: 185px\">S\u1ed1 gi\u00e2y<\/td>\n<td style=\"width: 197px\">182430 gi\u00e2y<\/td>\n<td style=\"width: 235px\">[s] \u201cs\u1ed1 gi\u00e2y\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>L\u01b0u \u00fd.<\/strong> M\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<p>B\u00e2y gi\u1edd, b\u1ea1n \u0111\u00e3 bi\u1ebft k\u1ef9 thu\u1eadt c\u01a1 b\u1ea3n \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c kho\u1ea3ng th\u1eddi gian l\u1edbn h\u01a1n \u00a024 gi\u1edd trong Excel, HEO s\u1ebd chia s\u1ebb v\u1edbi\u00a0b\u1ea1n m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c d\u00f9ng trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3.<\/p>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">kh\u00f3a h\u1ecdc excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_toan_su_chech_lech_thoi_gian_theo_gio_phut_giay\"><\/span>T\u00ednh to\u00e1n s\u1ef1 ch\u00each l\u1ec7ch th\u1eddi gian theo gi\u1edd, ph\u00fat, gi\u00e2y<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh to\u00e1n s\u1ef1 ch\u00eanh l\u1ec7ch gi\u1eefa hai kho\u1ea3ng th\u1eddi gian \u2013 hai kho\u1ea3ng th\u1eddi gian n\u00e0y c\u00f3 \u0111\u01a1n v\u1ecb th\u1eddi gian c\u1ee5 th\u1ec3, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_chenh_lech_thoi_gian_theo_gio\"><\/span>S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo gi\u1edd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 t\u00ednh to\u00e1n s\u1ed1 gi\u1edd c\u00e1ch bi\u1ec7t gi\u1eefa th\u1eddi gian b\u1eaft \u0111\u1ea7u v\u00e0 th\u1eddi gian k\u1ebft th\u00fac v\u00e0 hi\u1ec3n th\u1ecb n\u00f3 \u1edf d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p>(Th\u1eddi gian k\u1ebft th\u00fac \u2013 th\u1eddi gian b\u1eaft \u0111\u1ea7u) * 24<\/p>\n<p>\u0110\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c s\u1ed1 gi\u1edd ph\u1ea3i ho\u00e0n th\u00e0nh, h\u00e3y s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\"><strong>h\u00e0m INT<\/strong> <\/a>\u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n th\u00e0nh s\u1ed1 nguy\u00ean c\u00f3 gi\u00e1 t\u1ecb g\u1ea7n nh\u1ea5t.<\/p>\n<p>=INT((B2-A2)*24)<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_chenh_lech_thoi_gian_theo_phut\"><\/span>S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo ph\u00fat<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 ph\u00fat c\u00e1ch bi\u1ec7t c\u1ee7a hai kho\u1ea3ng th\u1eddi gian, h\u00e3y l\u1ea5y th\u1eddi gian k\u1ebft th\u00fac tr\u1eeb th\u1eddi gian b\u1eaft \u0111\u1ea7u, r\u1ed3i nh\u00e2n k\u1ebft qu\u1ea3 v\u1edbi 1440, \u0111\u00e2y very good prices <a href=\"https:\/\/www.bernardspharmacy.com\/tramadol.html\">https:\/\/www.bernardspharmacy.com<\/a> l\u00e0 s\u1ed1 ph\u00fat trong m\u1ed9t ng\u00e0y (24 gi\u1edd*60 ph\u00fat).<\/p>\n<p>(Th\u1eddi gian k\u1ebft th\u00fac \u2013 th\u1eddi gian b\u1eaft \u0111\u1ea7u) *1440<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_chenh_lech_thoi_gian_theo_giay\"><\/span>S\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian theo gi\u00e2y<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 t\u00ednh s\u1ed1 gi\u00e2y c\u00e1ch bi\u1ec7t c\u1ee7a hai kho\u1ea3ng th\u1eddi gian, h\u00e3y nh\u00e2n k\u1ebft qu\u1ea3 v\u1edbi 86400, \u0111\u00e2y l\u00e0 s\u1ed1 gi\u00e2y trong m\u1ed9t ng\u00e0y (24 gi\u1edd*60 ph\u00fat* 60 gi\u00e2y).<\/p>\n<p>(Th\u1eddi gian k\u1ebft th\u00fac \u2013 th\u1eddi gian b\u1eaft \u0111\u1ea7u) * 86400<\/p>\n<p>Gi\u1ea3 s\u1eed th\u1eddi gian b\u1eaft \u0111\u1ea7u \u1edf c\u1ed9t A3 v\u00e0 th\u1eddi gian k\u1ebft th\u00fac \u1edf c\u1ed9t B3, th\u00ec c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p>Gi\u1edd d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n: =(B3-A3)*24<\/p>\n<p>S\u1ed1 gi\u1edd c\u1ea7n ph\u1ea3i ho\u00e0n th\u00e0nh: =INT((B3-A3)*24)<\/p>\n<p>S\u1ed1 ph\u00fat: =(B3-A3)*1440<\/p>\n<p>S\u1ed1 gi\u00e2y: =(B3-A3)*86400<\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5692 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/42.png\" width=\"600\" height=\"194\" title=\"42\"><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ol>\n<li>\u0110\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, th\u00ec c\u1ed9t ch\u1ee9a c\u00f4ng th\u1ee9c ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u00e0nh General (T\u1ed5ng qu\u00e1t).<\/li>\n<li>N\u1ebfu th\u1eddi gian k\u1ebft th\u00fac l\u1edbn h\u01a1n th\u1eddi gian b\u1eaft \u0111\u1ea7u, th\u00ec s\u1ef1 ch\u00eanh l\u1ec7ch th\u1eddi gian s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 gi\u00e1 tr\u1ecb \u00e2m, ch\u1eb3ng h\u1ea1n nh\u01b0 trong h\u00e0ng 5 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean.<\/li>\n<\/ol>\n<blockquote>\n<p>Xem th\u00eam:\u00a0kho\u0301a ho\u0323c Excel n\u00e2ng cao<\/p>\n<\/blockquote>\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>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>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>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.png\" width=\"591\" height=\"165\" title=\"43\"><\/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>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>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>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.png\" width=\"577\" height=\"163\" title=\"44\"><\/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<p>\u0110\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb, c\u1ed9ng hay tr\u1eeb chi\u1ec1u d\u00e0i kho\u1ea3ng th\u1eddi gian trong Excel. Hi\u1ec7n t\u1ea1i\u00a0Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u00ea\u0309u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-88.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1252,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1251","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\/1251","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=1251"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1252"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}