{"id":10343,"date":"2025-01-13T15:31:34","date_gmt":"2025-01-13T15:31:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/cach-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay\/"},"modified":"2025-01-13T15:31:34","modified_gmt":"2025-01-13T15:31:34","slug":"cach-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/cach-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay\/","title":{"rendered":"C\u00e1ch s\u1eeda \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian b\u1ecb l\u1ed7i v\u1ec1 d\u1ea1ng chu\u1ea9n c\u1ea3 gi\u1edd ph\u00fat gi\u00e2y"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>L\u1ed7i d\u1eef li\u1ec7u v\u1ec1 th\u1eddi gian l\u00e0 m\u1ed9t l\u1ed7i kh\u00e1\u00a0hay g\u1eb7p\u00a0trong Excel. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta h\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1ch s\u1eeda \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian\u00a0b\u1ecb l\u1ed7i v\u1ec1 d\u1ea1ng chu\u1ea9n c\u1ea3 gi\u1edd ph\u00fat gi\u00e2y. \u0110\u00e2y l\u00e0 m\u1ed9t l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c ph\u1ea7n m\u1ec1m ra Excel. \u0110\u1ec3 l\u00e0m r\u00f5 h\u01a1n n\u1ed9i dung n\u00e0y, ch\u00fang ta c\u00f9ng x\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p>Nh\u1eefng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m kh\u00e1c ra Excel. Trong \u0111\u00f3 nh\u1eefng d\u1eef li\u1ec7u t\u1ea1i c\u1ed9t A th\u1ec3 hi\u1ec3n c\u00e1c gi\u00e1 tr\u1ecb th\u1eddi gian bao g\u1ed3m c\u1ea3 gi\u1edd, ph\u00fat, gi\u00e2y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20253\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-thoi-gian-ngay-gio-de-bai.png\" width=\"203\" height=\"283\" title=\"loi-thoi-gian-ngay-gio-de-bai\"><\/p>\n<p>Tuy nhi\u00ean nh\u1eefng d\u1eef li\u1ec7u tr\u00ean l\u1ea1i kh\u00f4ng d\u00f9ng ngay \u0111\u01b0\u1ee3c \u0111\u1ec3 t\u00ednh to\u00e1n, b\u00e1o c\u00e1o b\u1edfi d\u1eef li\u1ec7u c\u00f3 l\u1ed7i. M\u1ed9t s\u1ed1 d\u1eef li\u1ec7u kh\u00f4ng \u0111\u00fang lo\u1ea1i d\u1eef li\u1ec7u l\u00e0 th\u1eddi gian m\u00e0 l\u00e0 lo\u1ea1i text, v\u0103n b\u1ea3n. \u0110\u1ec3 gi\u00fap x\u00e1c \u0111\u1ecbnh\u00a0c\u00e1c l\u1ed7i v\u00e0 l\u00e0m chu\u1ea9n h\u00f3a l\u1ea1i d\u1eef li\u1ec7u, ch\u00fang ta th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-678531d56753e\" 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-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Kiem_tra_loi_du_lieu_thoi_gian\" title=\"Ki\u1ec3m tra l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian\">Ki\u1ec3m tra l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian<\/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-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Sua_loi_du_lieu_ngay_thang_voi_ham_VALUE_ket_hop_ham_TEXT\" title=\"S\u1eeda l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m VALUE k\u1ebft h\u1ee3p h\u00e0m TEXT\">S\u1eeda l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m VALUE k\u1ebft h\u1ee3p h\u00e0m TEXT<\/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-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Buoc_1_Dung_ham_Text_de_chuyen_het_cac_giu_lieu_ve_dang_Text_nhung_van_giu_nguyen_cach_dinh_dang\" title=\"B\u01b0\u1edbc 1: D\u00f9ng h\u00e0m Text \u0111\u1ec3 chuy\u1ec3n h\u1ebft c\u00e1c gi\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng Text nh\u01b0ng v\u1eabn gi\u1eef nguy\u00ean c\u00e1ch \u0111\u1ecbnh d\u1ea1ng\">B\u01b0\u1edbc 1: D\u00f9ng h\u00e0m Text \u0111\u1ec3 chuy\u1ec3n h\u1ebft c\u00e1c gi\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng Text nh\u01b0ng v\u1eabn gi\u1eef nguy\u00ean c\u00e1ch \u0111\u1ecbnh d\u1ea1ng<\/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-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Buoc_2_Chuyen_cac_du_lieu_dang_Text_ve_dang_Value\" title=\"B\u01b0\u1edbc 2: Chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng Text v\u1ec1 d\u1ea1ng Value\">B\u01b0\u1edbc 2: Chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng Text v\u1ec1 d\u1ea1ng Value<\/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-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Buoc_3_Dinh_dang_du_lieu_ket_qua_ve_dang_thoi_gian\" title=\"B\u01b0\u1edbc 3: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 v\u1ec1 d\u1ea1ng th\u1eddi gian\">B\u01b0\u1edbc 3: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 v\u1ec1 d\u1ea1ng th\u1eddi gian<\/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-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Sua_loi_du_lieu_thoi_gian_bang_Paste_Special\" title=\"S\u1eeda l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian b\u1eb1ng Paste Special\">S\u1eeda l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian b\u1eb1ng Paste Special<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Kiem_tra_loi_du_lieu_thoi_gian\"><\/span>Ki\u1ec3m tra l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1eb7c tr\u01b0ng c\u1ee7a d\u1eef li\u1ec7u th\u1eddi gian l\u00e0 n\u00f3 thu\u1ed9c lo\u1ea1i d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1 ch\u1ee9 kh\u00f4ng ph\u1ea3i ki\u1ec3u text. Ch\u00fang ta ki\u1ec3m tra d\u1eef li\u1ec7u v\u1edbi h\u00e0m IsText ho\u1eb7c h\u00e0m IsNumber nh\u01b0 sau<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20256\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/kiem-tra-loi-du-lieu-thoi-gian-voi-isnumber.png\" width=\"474\" height=\"279\" title=\"kiem-tra-loi-du-lieu-thoi-gian-voi-isnumber\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean khi s\u1eed d\u1ee5ng h\u00e0m IsNumber ki\u1ec3m tra lo\u1ea1i d\u1eef li\u1ec7u t\u1ea1i c\u1ed9t A th\u00ec ph\u00e1t hi\u1ec7n c\u00f3 t\u1edbi 4 n\u1ed9i dung ra k\u1ebft qu\u1ea3 False. Nh\u01b0 v\u1eady 4 v\u1ecb tr\u00ed \u0111\u00f3 kh\u00f4ng ph\u1ea3i lo\u1ea1i d\u1eef li\u1ec7u th\u1eddi gian chu\u1ea9n m\u00e0 l\u00e0 d\u1ea1ng text. \u0110\u1eb7c tr\u01b0ng c\u1ee7a lo\u1ea1i d\u1eef li\u1ec7u n\u00e0y l\u00e0 c\u00f3 \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh n\u1eb1m v\u1ec1 b\u00ean tr\u00e1i trong \u00f4.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-158.gif\" title=\"ex101_92019-nho-158\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\">C\u00e1ch ph\u00e2n bi\u1ec7t d\u1ea1ng d\u1eef li\u1ec7u trong Excel v\u1edbi nh\u00f3m h\u00e0m IsNumber, IsNonText, IsText<\/a><\/p>\n<p>Sau khi ph\u00e1t hi\u1ec7n ra d\u1eef li\u1ec7u c\u00f3 l\u1ed7i, ch\u00fang ta s\u1ebd ph\u1ea3i ti\u1ebfn h\u00e0nh c\u00e1c b\u01b0\u1edbc s\u1eeda l\u1ed7i d\u1eef li\u1ec7u n\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sua_loi_du_lieu_ngay_thang_voi_ham_VALUE_ket_hop_ham_TEXT\"><\/span>S\u1eeda l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m VALUE k\u1ebft h\u1ee3p h\u00e0m TEXT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html\">H\u00e0m TEXT<\/a> l\u00e0 m\u1ed9t h\u00e0m gi\u00fap \u0111\u01b0a t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 v\u1ec1 d\u1ea1ng text nh\u01b0ng v\u1eabn\u00a0c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng theo \u00fd mu\u1ed1n c\u1ee7a d\u1ea1ng S\u1ed1, Ng\u00e0y th\u00e1ng.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\">H\u00e0m VALUE<\/a> gi\u00fap chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb d\u1ea1ng Text v\u1ec1 d\u1ea1ng gi\u00e1 tr\u1ecb (S\u1ed1 ho\u1eb7c Ng\u00e0y th\u00e1ng)<\/p>\n<p>Trong y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta nh\u1eadn th\u1ea5y c\u00e1c d\u1eef li\u1ec7u v\u1eeba c\u00f3 d\u1ea1ng Text, v\u1eeba c\u00f3 d\u1ea1ng Ng\u00e0y th\u00e1ng. Do \u0111\u00f3 \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u1ed9ng nh\u1ea5t d\u1eef li\u1ec7u th\u00ec ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Dung_ham_Text_de_chuyen_het_cac_giu_lieu_ve_dang_Text_nhung_van_giu_nguyen_cach_dinh_dang\"><\/span>B\u01b0\u1edbc 1: D\u00f9ng h\u00e0m Text \u0111\u1ec3 chuy\u1ec3n h\u1ebft c\u00e1c gi\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng Text nh\u01b0ng v\u1eabn gi\u1eef nguy\u00ean c\u00e1ch \u0111\u1ecbnh d\u1ea1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20257\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sua-loi-du-lieu-thoi-gian-voi-ham-text.png\" width=\"604\" height=\"328\" title=\"sua-loi-du-lieu-thoi-gian-voi-ham-text\"><\/p>\n<p>Trong c\u00e1ch l\u00e0m n\u00e0y, ch\u00fang ta c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh \u0111\u00fang lo\u1ea1i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian c\u1ee7a d\u1eef li\u1ec7u trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u201cdd\/mm\/yyyy hh:mm:ss\u201d, t\u1ee9c l\u00e0 g\u1ed3m \u0111\u1ee7 ng\u00e0y th\u00e1ng n\u0103m + gi\u1edd ph\u00fat gi\u00e2y ng\u0103n c\u00e1ch v\u1edbi nhau b\u1edfi d\u1ea5u c\u00e1ch.<\/p>\n<p style=\"padding-left: 30px\">C\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng n\u0103m ng\u0103n c\u00e1ch nhau b\u1edfi d\u1ea5u g\u1ea1ch ch\u00e9o (\/)<\/p>\n<p style=\"padding-left: 30px\">C\u00e1c gi\u00e1 tr\u1ecb gi\u1edd ph\u00fat gi\u00e2y ng\u0103n c\u00e1ch nhau b\u1edfi d\u1ea5u hai ch\u1ea5m (:)<\/p>\n<p>Khi \u0111\u00f3 to\u00e0n b\u1ed9 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n v\u1ec1 d\u1ea1ng Text.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Chuyen_cac_du_lieu_dang_Text_ve_dang_Value\"><\/span>B\u01b0\u1edbc 2: Chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng Text v\u1ec1 d\u1ea1ng Value<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>S\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m TEXT v\u1ec1 d\u1ea1ng gi\u00e1 tr\u1ecb th\u1eddi gian nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20258\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sua-loi-du-lieu-thoi-gian-voi-ham-value.png\" width=\"768\" height=\"323\" title=\"sua-loi-du-lieu-thoi-gian-voi-ham-value\"><\/p>\n<p>T\u1ea1i c\u1ed9t D d\u00f9ng h\u00e0m VALUE. \u0110\u1ed1i t\u01b0\u1ee3ng c\u1ea7n chuy\u1ec3n l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t B<\/p>\n<p>T\u1ea1i c\u1ed9t E ki\u1ec3m tra b\u1eb1ng h\u00e0m IsNumber ra k\u1ebft qu\u1ea3 \u0111\u1ec1u l\u00e0 TRUE<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Dinh_dang_du_lieu_ket_qua_ve_dang_thoi_gian\"><\/span>B\u01b0\u1edbc 3: \u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 v\u1ec1 d\u1ea1ng th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>CH\u00fang ta th\u1ea5y trong c\u1ed9t D d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi d\u1ea1ng con s\u1ed1. \u0110\u00e2y ch\u00ednh l\u00e0 d\u1ea1ng quy \u01b0\u1edbc c\u1ee7a d\u1eef li\u1ec7u th\u1eddi gian khi trong ch\u1ebf \u0111\u1ed9 \u0111\u1ecbnh d\u1ea1ng General (m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel). \u0110\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u n\u00e0y v\u1ec1 d\u1ea1ng th\u1eddi gian \u0111\u1ea7y \u0111\u1ee7 ng\u00e0y gi\u1edd th\u00ec ch\u00fang ta th\u1ef1c hi\u1ec7n Format Cells nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng<\/li>\n<li>M\u1edf c\u1eeda s\u1ed5 Format Cells ch\u1ecdn Custom<\/li>\n<li>Trong m\u1ee5c Type vi\u1ebft c\u00e1c k\u00fd t\u1ef1 sau: dd\/mm\/yyyy hh:mm:ss<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20259\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/dinh-dang-du-lieu-thoi-gian-ve-chuan.png\" width=\"874\" height=\"447\" title=\"dinh-dang-du-lieu-thoi-gian-ve-chuan\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n r\u1ed3i.<\/p>\n<p>Ngo\u00e0i ra ch\u00fang ta c\u00f3 th\u1ec3 l\u1ed3ng gh\u00e9p h\u00e0m Text tr\u1ef1c ti\u1ebfp v\u00e0o b\u00ean trong h\u00e0m Value \u0111\u1ec3 c\u00f3 th\u1ec3 r\u00fat ng\u1eafn c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20260\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sua-loi-du-lieu-thoi-gian-voi-ham-value-ket-hop-text.png\" width=\"1109\" height=\"283\" title=\"sua-loi-du-lieu-thoi-gian-voi-ham-value-ket-hop-text\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sua_loi_du_lieu_thoi_gian_bang_Paste_Special\"><\/span>S\u1eeda l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian b\u1eb1ng Paste Special<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ngo\u00e0i ra ch\u00fang ta c\u00f2n c\u00f3 1 c\u00e1ch n\u1eefa kh\u00e1 \u0111\u01a1n gi\u1ea3n nh\u01b0ng l\u1ea1i r\u1ea5t hi\u1ec7u qu\u1ea3, \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Paste Special. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u (click chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u trong c\u1ed9t d\u1eef li\u1ec7u r\u1ed3i b\u1ea5m ph\u00edm t\u1eaft Ctrl+Shift+ M\u0169i t\u00ean xu\u1ed1ng)<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Copy v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: T\u1ea1i v\u1ecb tr\u00ed mu\u1ed1n d\u00e1n k\u1ebft qu\u1ea3, b\u1ea5m ch\u1ecdn <strong>Paste Special<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20884\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/paste-special-sua-loi-thoi-gian-01.png\" width=\"595\" height=\"275\" title=\"paste-special-sua-loi-thoi-gian-01\"><\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: Trong c\u1eeda s\u1ed5 Paste Special ch\u1ecdn <strong>Add<\/strong> trong ph\u1ea7n <strong>Operation<\/strong> r\u1ed3i b\u1ea5m OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20885\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/paste-special-sua-loi-thoi-gian-operation-add.png\" width=\"861\" height=\"431\" title=\"paste-special-sua-loi-thoi-gian-operation-add\"><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 ch\u00fang ta c\u00f3 \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u m\u1edbi \u0111\u00e3 s\u1eeda l\u1ea1i \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng theo y\u00eau c\u1ea7u<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20886\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/paste-special-sua-loi-thoi-gian-ket-qua.png\" width=\"682\" height=\"258\" title=\"paste-special-sua-loi-thoi-gian-ket-qua\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta bi\u1ebft t\u1edbi 1 ph\u01b0\u01a1ng ph\u00e1p r\u1ea5t nhanh v\u00e0 hi\u1ec7u qu\u1ea3 gi\u00fap x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian: \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m VALUE k\u1ebft h\u1ee3p v\u1edbi h\u00e0m TEXT. Khi k\u1ebft h\u1ee3p 2 h\u00e0m n\u00e0y th\u00ec vi\u1ec7c x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian kh\u00f4ng c\u00f2n kh\u00f3 n\u1eefa.<\/p>\n<p>K\u1ebft h\u1ee3p th\u00eam v\u1edbi ph\u01b0\u01a1ng ph\u00e1p Paste Special ch\u00fang ta c\u00f3 th\u00eam \u0111\u01b0\u1ee3c 1 c\u00e1ch r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3, gi\u00fap vi\u1ec7c x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u th\u1eddi gian, d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n bao gi\u1edd h\u1ebft.<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c ki\u1ebfn th\u1ee9c kh\u00e1c v\u1ec1 d\u1eef li\u1ec7u th\u1eddi gian trong Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng trong Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng trong \u00f4 tr\u00ean Excel<\/a><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y \u0111\u1ec1u c\u00f3 trong kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2L1C2VH\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online<\/a>. B\u1ea1n mu\u1ed1n bi\u1ebft th\u00eam nhi\u1ec1u h\u00e0m trong Excel, s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c c\u00f4ng c\u1ee5 c\u00f3 tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a Excel? H\u00e3y tham gia ngay kh\u00f3a h\u1ecdc \u0111\u1ec3 t\u00ecm hi\u1ec3u nh\u00e9. Ngo\u00e0i ra c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc t\u1ea1i \u0111\u1ecba ch\u1ec9 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-158.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10344,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10343","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\/10343","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=10343"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10343\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10344"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}