{"id":2457,"date":"2024-12-02T07:51:34","date_gmt":"2024-12-02T07:51:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-chuyen-doi-thoi-gian-thanh-so-thap-phan-gio-phut-giay-trong-excel\/"},"modified":"2024-12-02T07:51:34","modified_gmt":"2024-12-02T07:51:34","slug":"cach-chuyen-doi-thoi-gian-thanh-so-thap-phan-gio-phut-giay-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-chuyen-doi-thoi-gian-thanh-so-thap-phan-gio-phut-giay-trong-excel\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n, gi\u1edd ph\u00fat gi\u00e2y trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>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 c\u00e1c b\u1ea1n nhi\u1ec1u c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n, \u0111\u1ed5i gi\u1edd ra ph\u00fat trong excel v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/em><\/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-674d670523ae2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cach_chuyen_doi_thoi_gian_thanh_so_thap_phan_trong_Excel\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n trong Excel:\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n trong Excel:<\/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\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cach_chuyen_doi_thoi_gian_thanh_gio_trong_Excel\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh gi\u1edd trong Excel:\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh gi\u1edd 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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_1_Phep_toan\" title=\"C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n\">C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n<\/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-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_2_Ham_CONVERT\" title=\"C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT\">C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT<\/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-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_3_Ham_HOUR_MINUTE_SECOND\" title=\"C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND\">C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cach_chuyen_doi_thoi_gian_thanh_phut_trong_Excel\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh ph\u00fat trong Excel\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh ph\u00fat trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_1_Phep_toan-2\" title=\"C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n\">C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_2_Ham_CONVERT-2\" title=\"C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT\">C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_3_Ham_HOUR_MINUTE_SECOND-2\" title=\"C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND\">C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cach_chuyen_doi_thoi_gian_thanh_giay_trong_Excel\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh gi\u00e2y trong Excel\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh gi\u00e2y 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-11\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_1_Phep_toan-3\" title=\"C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n\">C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_2_Ham_CONVERT-3\" title=\"C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT\">C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT<\/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-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cong_thuc_3_Ham_HOUR_MINUTE_SECOND-3\" title=\"C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND\">C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND<\/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-14\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cach_tach_ngay_thang_va_gio_trong_Excel\" title=\"C\u00e1ch t\u00e1ch ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd trong Excel\">C\u00e1ch t\u00e1ch ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Cach_viet_thoi_gian_bang_chu_trong_Excel\" title=\"C\u00e1ch vi\u1ebft th\u1eddi gian b\u1eb1ng ch\u1eef trong Excel\">C\u00e1ch vi\u1ebft th\u1eddi gian b\u1eb1ng ch\u1eef trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Chuyen_doi_dinh_dang_text_thanh_time_trong_Excel\" title=\"Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng text th\u00e0nh time trong Excel\">Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng text th\u00e0nh time trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Chuyen_doi_dinh_dang_time_thanh_text_trong_Excel\" title=\"Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng time th\u00e0nh text trong Excel\">Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng time th\u00e0nh text trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-doi-thoi-gian-thanh-thap-phan-gio-phut-giay-trong-excel.html#Chuyen_doi_dinh_dang_number_thanh_time_trong_Excel\" title=\"Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh time trong Excel\">Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh time trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_thoi_gian_thanh_so_thap_phan_trong_Excel\"><\/span><strong>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u00ecn chung, c\u00f3 3 c\u00e1ch \u0111\u1ec3 chuy\u1ec3n gi\u00e1 tr\u1ecb th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n\u00a0: ph\u00e9p to\u00e1n, h\u00e0m <strong><em>CONVERT<\/em><\/strong> ho\u1eb7c l\u1ed3ng gh\u00e9p 3 h\u00e0m th\u1eddi gian v\u1edbi nhau.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n trong Excel l\u00e0 nh\u00e2n gi\u00e1 tr\u1ecb th\u1eddi gian g\u1ed1c v\u1edbi s\u1ed1 gi\u1edd, ph\u00fat, gi\u00e2y trong ng\u00e0y:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian sang gi\u1edd, nh\u00e2n s\u1ed1 th\u1eddi gian v\u1edbi 24 (s\u1ed1 gi\u1edd trong m\u1ed9t ng\u00e0y).<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian sang ph\u00fat, nh\u00e2n v\u1edbi th\u1eddi gian v\u1edbi 1440 (s\u1ed1 ph\u00fat trong m\u1ed9t ng\u00e0y = 24 * 60).<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian sang gi\u00e2y, nh\u00e2n v\u1edbi th\u1eddi gian v\u1edbi 86400 (s\u1ed1 gi\u00e2y trong m\u1ed9t ng\u00e0y = 24 * 60 * 60).<\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-time-decimal-excel.png\" alt=\"Convert time to a decimal number in Excel\" title=\"convert-time-decimal-excel\"><\/strong><\/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-82.gif\" title=\"vba101_92019-nho-82\"><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-190.gif\" title=\"ex101_92019-nho-190\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_thoi_gian_thanh_gio_trong_Excel\"><\/span><strong>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh gi\u1edd trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ph\u1ea7n n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn 3 c\u00f4ng th\u1ee9c kh\u00e1c nhau \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1edd t\u1eeb \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian ti\u00eau chu\u1ea9n (hh:mm:ss) th\u00e0nh m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Phep_toan\"><\/span><strong>C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1eddi gian th\u00e0nh s\u1ed1 gi\u1edd trong Excel \u2013 b\u1eb1ng c\u00e1ch nh\u00e2n v\u1edbi 24, c\u1ee5 th\u1ec3 l\u00e0 s\u1ed1 gi\u1edd trong m\u1ed9t ng\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>=A2*24 <\/strong>(A2 l\u00e0 gi\u00e1 tr\u1ecb th\u1eddi gian)<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u1ea5y Complete hours, nh\u1eadp c\u00f4ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\" target=\"_blank\" rel=\"noopener\">h\u00e0m <strong><em>INT<\/em><\/strong><\/a> \u0111\u1ec3 b\u1ecf ph\u1ea7n l\u1ebb: <strong><em>=INT(A2*24)<\/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-convert-time-hours.png\" alt=\"The formula and arithmetic calculation to convert time to hours in Excel\" title=\"excel-convert-time-hours\"><\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Ham_CONVERT\"><\/span><strong>C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian &gt; gi\u1edd l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>CONVERT<\/em><\/strong>:<\/p>\n<p style=\"text-align: justify\"><strong><em>=CONVERT(A2, \u201cday\u201d, \u201chr\u201d)<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_3_Ham_HOUR_MINUTE_SECOND\"><\/span><strong>C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n. Xu\u1ea5t c\u00e1c \u0111\u01a1n v\u1ecb th\u1eddi gian b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-thoi-gian-thong-dung-trong-excel.html\" target=\"_blank\" rel=\"noopener\">c\u00e1c h\u00e0m th\u1eddi gian<\/a>\u00a0\u00a0<strong><em>HOUR, MINUTE, SECOND<\/em><\/strong> sau \u0111\u00f3 chia s\u1ed1 ph\u00fat cho 60 v\u00e0 chia s\u1ed1 gi\u00e2y cho 3600 v\u00e0 t\u00ednh to\u00e1n k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><strong><em>=HOUR(A2) + MINUTE(A2)\/60 + SECOND(A2)\/3600<\/em><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_thoi_gian_thanh_phut_trong_Excel\"><\/span><strong>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh ph\u00fat trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ba ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng t\u1ef1 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ph\u00fat t\u1eeb \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian ti\u00eau chu\u1ea9n th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Phep_toan-2\"><\/span><strong>C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh ph\u00fat, b\u1ea1n nh\u00e2n th\u1eddi gian v\u1edbi 1440 \u2013 s\u1ed1 ph\u00fat trong m\u1ed9t ng\u00e0y (24 gi\u1edd * 60 ph\u00fat = 1440 ph\u00fat):<\/p>\n<p style=\"text-align: justify\"><strong><em>=A2*1440<\/em><\/strong> (A2 l\u00e0 gi\u00e1 tr\u1ecb th\u1eddi gian)<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u1ea5y Complete minutes, nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m <strong><em>INT<\/em><\/strong> nh\u01b0 v\u00ed d\u1ee5 tr\u01b0\u1edbc: <strong><em>=INT(A2*1440)<\/em><\/strong>. K\u1ebft qu\u1ea3 nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/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-convert-time-minutes.png\" alt=\"Converting time to minutes in Excel\" title=\"excel-convert-time-minutes\"><\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Ham_CONVERT-2\"><\/span><strong>C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1edd &gt; ph\u00fat b\u1eb1ng h\u00e0m <strong><em>CONVERT(number, from_unit, to_unit)<\/em><\/strong>, cung c\u1ea5p \u2018day\u2019 l\u00e0 \u0111\u01a1n v\u1ecb \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i v\u00e0 \u2018mn\u2019 l\u00e0 \u0111\u01a1n v\u1ecb chuy\u1ec3n \u0111\u1ed5i th\u00e0nh:<\/p>\n<p style=\"text-align: justify\"><strong><em>=CONVERT(A2, \u201cday\u201d, \u201cmn\u201d)<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_3_Ham_HOUR_MINUTE_SECOND-2\"><\/span><strong>C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 l\u1ea5y s\u1ed1 ph\u00fat l\u00e0 nh\u00e2n s\u1ed1 gi\u1edd v\u1edbi 60, chia s\u1ed1 gi\u00e2y cho 60:<\/p>\n<p style=\"text-align: justify\"><strong><em>=HOUR(A2)*60 + MINUTE(A2) + SECOND(A2)\/60<\/em><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_thoi_gian_thanh_giay_trong_Excel\"><\/span><strong>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh gi\u00e2y 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_Phep_toan-3\"><\/span><strong>C\u00f4ng th\u1ee9c 1: Ph\u00e9p to\u00e1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u00e2n th\u1eddi gian v\u1edbi 86400 \u2013 s\u1ed1 gi\u00e2y trong m\u1ed9t ng\u00e0y (24 gi\u1edd * 60 ph\u00fat * 60 gi\u00e2y = 86400)<\/p>\n<p style=\"text-align: justify\"><strong><em>=A2*86400<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-convert-time-seconds.png\" alt=\"Converting time to seconds in Excel\" title=\"excel-convert-time-seconds\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Ham_CONVERT-3\"><\/span><strong>C\u00f4ng th\u1ee9c 2: H\u00e0m CONVERT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 v\u00ed d\u1ee5 b\u00ean tr\u00ean, ch\u1ec9 kh\u00e1c \u1edf vi\u1ec7c thay \u0111\u01a1n v\u1ecb \u2018day\u2019 th\u00e0nh \u2018sec\u2019:<\/p>\n<p style=\"text-align: justify\"><strong><em>=CONVERT(A2, \u201cday\u201d, \u201csec\u201d)<\/em><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_3_Ham_HOUR_MINUTE_SECOND-3\"><\/span><strong>C\u00f4ng th\u1ee9c 3: H\u00e0m HOUR, MINUTE, SECOND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m<strong><em> HOUR, MINUTE, SECOND<\/em><\/strong> nh\u01b0 hai v\u00ed d\u1ee5 tr\u01b0\u1edbc:<\/p>\n<p style=\"text-align: justify\"><strong><em>=HOUR(A2)*3600 + MINUTE(A2)*60 + SECOND(A2)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<ol style=\"text-align: justify\">\n<li>N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c n\u00e0o cho k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ecbnh d\u1ea1ng <strong><em>time<\/em><\/strong>, ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u00e0nh <strong><em>General <\/em><\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb s\u1ed1.<\/li>\n<li>\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n, \u0111\u1ecbnh d\u1ea1ng <strong><em>General <\/em><\/strong>cho \u00f4 t\u00ednh. Nh\u01b0 v\u1eady, 23:59:59 s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh 0.99999, 06:00 AM th\u00e0nh 0.25, v\u00e0 12:00 PM th\u00e0nh 0.5. N\u1ebfu ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 chuy\u1ec3n \u0111\u1ed5i l\u1edbn h\u01a1n 0, \u0111i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 \u00f4 t\u00ednh c\u1ee7a b\u1ea1n \u0111ang ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ee7a ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian.<\/li>\n<\/ol>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tach_ngay_thang_va_gio_trong_Excel\"><\/span><strong>C\u00e1ch t\u00e1ch ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 th\u01b0\u1eddng th\u1ea5y, trang t\u00ednh Excel c\u00f3 th\u1ec3 ch\u1ee9a ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong c\u00f9ng m\u1ed9t \u00f4 t\u00ednh, trong khi b\u1ea1n mu\u1ed1n t\u00e1ch ch\u00fang ra th\u00e0nh hai \u00f4 ri\u00eang bi\u1ec7t.<\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb r\u1eb1ng trong h\u1ec7 th\u1ed1ng Excel, gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf ph\u1ea7n nguy\u00ean v\u00e0 gi\u00e1 tr\u1ecb th\u1eddi gian \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb th\u00e0nh ph\u1ea7n l\u1ebb th\u1eadp ph\u00e2n. B\u1ea1n c\u00f3 th\u1ec3 xu\u1ea5t gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng b\u1eb1ng h\u00e0m <strong><em>INT <\/em><\/strong>\u2013 h\u00e0m n\u00e0y s\u1ebd l\u00e0m tr\u00f2n \u00f4 t\u00ednh theo gi\u00e1 tr\u1ecb nguy\u00ean g\u1ea7n nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian g\u1ed1c trong c\u1ed9t A, c\u00f4ng th\u1ee9c sau s\u1ebd ho\u00e0n th\u00e0nh vi\u1ec7c t\u00e1ch:<\/p>\n<p style=\"text-align: justify\"><strong><em>=INT(A2)<\/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\/extract-date-value.png\" alt=\"Use the INT function to extract the date values\" title=\"extract-date-value\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xu\u1ea5t ph\u1ea7n th\u1eddi gian, tr\u1eeb k\u1ebft qu\u1ea3 m\u1edbi nh\u1eadn \u0111\u01b0\u1ee3c cho gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian g\u1ed1c\u00a0:<\/p>\n<p style=\"text-align: justify\"><strong><em>=A2-B2<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u1ed9t A ch\u1ee9a gi\u00e1 tr\u1ecb th\u1eddi gian v\u00e0 ng\u00e0y th\u00e1ng g\u1ed1c, c\u1ed9t B ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c t\u00ednh b\u1edfi h\u00e0m <strong><em>INT<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n gi\u00e1 tr\u1ecb th\u1eddi gian li\u00ean k\u1ebft v\u1edbi ph\u1ea7n ng\u00e0y th\u00e1ng (v\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n x\u00f3a c\u1ed9t ng\u00e0y th\u00e1ng sau n\u00e0y), b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-mode-ham-tim-tan-xuat-lon-nhat-trong-excel.html\" target=\"_blank\" rel=\"noopener\">h\u00e0m\u00a0<strong><em>MOD<\/em><\/strong><\/a>, c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=MOD(A2,1)<\/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-split-date-time.png\" alt=\"Splitting date and time in Excel\" title=\"excel-split-date-time\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu ph\u1ea7n ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian kh\u00f4ng hi\u1ec3n th\u1ecb theo \u00fd b\u1ea1n, thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u1ed9t m\u1edbi l\u1ea7n l\u01b0\u1ee3t th\u00e0nh \u00a0<strong><em>Date <\/em><\/strong>v\u00e0 <strong><em>Time<\/em><\/strong>.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_viet_thoi_gian_bang_chu_trong_Excel\"><\/span><strong>C\u00e1ch vi\u1ebft th\u1eddi gian b\u1eb1ng ch\u1eef trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u00f4i khi, b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh \u0111\u1ecbnh d\u1ea1ng \u201c# ng\u00e0y, # gi\u1edd, # ph\u00fat v\u00e0 # gi\u00e2y\u201d. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c:<\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eed d\u1ee5ng h\u00e0m <strong><em>INT <\/em><\/strong>\u0111\u1ec3 xu\u1ea5t ng\u00e0y<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m <strong><em>HOUR, MINUTE<\/em><\/strong> v\u00e0 <strong><em>SECOND<\/em><\/strong> \u0111\u1ec3 xu\u1ea5t c\u00e1c \u0111\u01a1n v\u1ecb t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<li>K\u1ebft n\u1ed1i t\u1ea5t c\u1ea3 th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 th\u1eddi \u0111i\u1ec3m t\u1ed5 ch\u1ee9c s\u1ef1 ki\u1ec7n trong c\u1ed9t B b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B4, v\u00e0 ng\u00e0y th\u00e1ng th\u1eddi gian hi\u1ec7n t\u1ea1i trong \u00f4 B1 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a <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\">h\u00e0m <strong><em>=NOW()<\/em><\/strong><\/a>.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh ch\u00eanh l\u1ec7ch th\u1eddi gian r\u1ea5t \u0111\u01a1n gi\u1ea3n= B4- $B$1. T\u1ea5t nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n b\u1ea1n tr\u1eeb th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i tr\u1ef1c ti\u1ebfp v\u1edbi <strong><em>= B4-NOW()<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, h\u00e3y t\u1ea1o m\u1ed9t b\u1ed9 \u0111\u1ebfm hi\u1ec3n th\u1ecb s\u1ed1 ng\u00e0y, gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y c\u00f2n l\u1ea1i \u0111\u1ebfn khi m\u1ed7i s\u1ef1 ki\u1ec7n x\u1ea3y ra.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-spell-time.png\" alt=\"Setting up a countdown timer in Excel\" title=\"excel-spell-time\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c trong \u00f4 D4 nh\u01b0 sau\u00a0:<\/p>\n<p style=\"text-align: justify\"><strong><em>=INT(C4) &amp; \u201d days, \u201d &amp; HOUR(C4) &amp; \u201d hours, \u201d &amp; MINUTE(C4) &amp; \u201d minutes and \u201d &amp; SECOND(C4) &amp; \u201d seconds\u201d<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6208\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-157.png\" width=\"600\" height=\"230\" title=\"excel-dialog-box-launcher-1-157\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n b\u1ecf gi\u00e1 tr\u1ecb 0 nh\u01b0 trong \u00f4 D6, D7 \u1edf tr\u00ean, h\u00e3y th\u00eam <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener\">h\u00e0m <strong><em>IF <\/em><\/strong><\/a>v\u00e0o nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong><em>=IF(INT(C4)&gt;0, INT(C4)&amp;\u201d days, \u201c,\u201d\u201d) &amp; IF(HOUR(C4)&gt;0, HOUR(C4) &amp; \u201d hours, \u201c,\u201d\u201d) &amp; IF(MINUTE(C4)&gt;0, MINUTE(C4) &amp; \u201d minutes and \u201c,\u201d\u201d) &amp; IF(SECOND(C4)&gt;0, SECOND(C4) &amp; \u201d seconds\u201d,\u201d\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb 0 \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6209\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-158.png\" width=\"600\" height=\"252\" title=\"excel-dialog-box-launcher-1-158\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>Khi m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean ra s\u1ed1 \u00e2m,<a href=\"http:\/\/blog.ezworkapp.com\/xu-ly-loi-cong-thuc-excel.html\" target=\"_blank\" rel=\"noopener\"> l\u1ed7i <strong><em>#NUM! <\/em><\/strong><\/a>s\u1ebd xu\u1ea5t hi\u1ec7n. \u0110i\u1ec1u n\u00e0y x\u1ea3y ra khi b\u1ea1n l\u1ea5y gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n tr\u1eeb cho th\u1eddi gian l\u1edbn h\u01a1n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuyen_doi_dinh_dang_text_thanh_time_trong_Excel\"><\/span><strong>Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng text th\u00e0nh time trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c th\u1eddi gian v\u00e0 c\u00e1c ph\u00e9p t\u00ednh kh\u00f4ng \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c, l\u1ed7i \u0111\u1ecbnh d\u1ea1ng text cho gi\u00e1 tr\u1ecb th\u1eddi gian c\u00f3 th\u1ec3 l\u00e0 nguy\u00ean nh\u00e2n. C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 ch\u1eefa l\u1ed7i l\u00e0 s\u1eed d\u1ee5ng h\u00e0m <strong><em>TIMEVALUE<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><strong><em>=TIMEVALUE(time_text)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>Time_text<\/em><\/strong> l\u00e0 chu\u1ed7i text m\u00e0 Excel c\u00f3 th\u1ec3 nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c trong b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian n\u00e0o, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>=TIMEVALUE(\u201c6:20 PM\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=TIMEVALUE(\u201c6-Jan-2015 6:20 PM\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>=TIMEVALUE(A2)<\/em><\/strong>, trong \u0111\u00f3 \u00f4 A2 ch\u1ee9a chu\u1ed7i text.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-timevalue.png\" alt=\"Convert text to time using the Excel TIMEVALUE function\" title=\"excel-timevalue\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, c\u00f4ng th\u1ee9c ch\u1ee9a \u00f4 tham chi\u1ebfu chu\u1ed7i text t\u01b0\u01a1ng \u1ee9ng cung c\u1ea5p k\u1ebft qu\u1ea3 gi\u1ed1ng h\u1ec7t nhau. Ngo\u00e0i ra, h\u00e3y ch\u00fa \u00fd \u0111\u1ebfn chu\u1ed7i th\u1eddi gian (gi\u00e1 tr\u1ecb text) \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 tr\u00e1i trong \u00f4 A2 v\u00e0 A6, \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 ph\u1ea3i sau khi chuy\u1ec3n \u0111\u1ed5i th\u00e0nh \u0111\u1ecbnh d\u1ea1ng time trong c\u1ed9t D.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuyen_doi_dinh_dang_time_thanh_text_trong_Excel\"><\/span><strong>Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng time th\u00e0nh text trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed, t\u1ec7p Excel c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng time nh\u01b0 \u201c8:30:00 AM\u201d v\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n ch\u00fang th\u00e0nh \u0111\u1ecbnh d\u1ea1ng text. Vi\u1ec7c thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4 sang text kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c b\u1edfi v\u00ec \u0111i\u1ec1u n\u00e0y s\u1ebd thay \u0111\u1ed5i gi\u00e1 tr\u1ecb th\u1eddi gian th\u00e0nh d\u1ea1ng s\u1ed1. V\u00ed d\u1ee5: 8:30:00 AM s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n 0.354166666666667<\/p>\n<p style=\"text-align: justify\">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\">h\u00e0m <strong><em>TEXT <\/em><\/strong><\/a>\u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb s\u1ed1 th\u00e0nh text, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong><em>=TEXT($A2,\u201dh:mm:ss\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda m\u1ed9t s\u1ed1 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-time-text-excel.png\" alt=\"Converting time to text in Excel\" title=\"convert-time-text-excel\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuyen_doi_dinh_dang_number_thanh_time_trong_Excel\"><\/span><strong>Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng number th\u00e0nh time trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 danh s\u00e1ch c\u00e1c s\u1ed1 nh\u01b0 1, 2, 3.5 v\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i ch\u00fang th\u00e0nh \u0111\u1ecbnh d\u1ea1ng gi\u1edd, v\u00ed d\u1ee5 1:00:00, 2:00:00 or 3:30 AM, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Chia c\u00e1c s\u1ed1 cho 24 (24 l\u00e0 s\u1ed1 gi\u1edd m\u1ed7i ng\u00e0y). C\u00f4ng th\u1ee9c <strong><em>=A2\/24<\/em><\/strong><\/li>\n<li>Ch\u1ecdn c\u00e1c \u00f4 t\u00ednh ch\u1ee9a k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c, nh\u1ea5p ph\u1ea3i v\u00e0 ch\u1ecdn <strong><em>Format Cells <\/em><\/strong>ho\u1eb7c nh\u1ea5n <strong><em>Ctrl + 1<\/em><\/strong>. H\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong> xu\u1ea5t hi\u1ec7n, ch\u1ecdn <strong><em>Time<\/em><\/strong> \u1edf ph\u00eda b\u00ean tr\u00e1i b\u1ea3ng b\u00ean d\u01b0\u1edbi <strong><em>Category<\/em><\/strong>, v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n \u1edf ph\u00eda b\u00ean ph\u1ea3i b\u1ea3ng b\u00ean d\u01b0\u1edbi <strong><em>Type<\/em><\/strong>.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-number-time-excel.png\" alt=\"Converting numbers to the time format in Excel\" title=\"convert-number-time-excel\"><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2vgmnb9\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. 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\/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-82.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2457","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\/2457","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=2457"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2457\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2458"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}