{"id":2547,"date":"2024-12-02T08:04:26","date_gmt":"2024-12-02T08:04:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian\/"},"modified":"2024-12-02T08:04:26","modified_gmt":"2024-12-02T08:04:26","slug":"dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian\/","title":{"rendered":"\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel &amp; c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOW v\u00e0 TIME \u0111\u1ec3 ch\u00e8n 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, Blog H\u1ecdc Excel Onnline s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c \u0111\u1eb7c t\u00ednh c\u1ee7a \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel c\u0169ng nh\u01b0 c\u00e1ch th\u00eam d\u1ea5u m\u1ed1c th\u1eddi gian b\u1eb1ng c\u00e1c ph\u00edm t\u1eaft ho\u1eb7c vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m NOW \u0111\u1ec3 ch\u00e8n th\u1eddi gian (m\u00e0 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng). B\u1ea1n c\u0169ng s\u1ebd h\u1ecdc c\u00e1ch \u00e1p d\u1ee5ng c\u00e1c h\u00e0m th\u1eddi gian trong Excel \u0111\u1ec3 cho ra k\u1ebft qu\u1ea3 l\u00e0 gi\u1edd, ph\u00fat ho\u1eb7c gi\u00e2y so v\u1edbi d\u1ea5u m\u1ed1c th\u1eddi gian \u0111\u00e3 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">Microsoft Excel c\u00f3 m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng th\u1eddi gian h\u1eefu \u00edch v\u00e0 vi\u1ec7c b\u1ea1n bi\u1ebft m\u1ed9t ch\u00fat v\u1ec1 ch\u00fang, \u0111\u00f4i khi c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian. Khi d\u00f9ng c\u00e1c h\u00e0m \u0111\u1eb7c bi\u1ec7t, th\u00ec b\u1ea1n c\u00f3 th\u1ec3: ch\u00e8n ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i v\u00e0o b\u1ea5t k\u1ef3 n\u01a1i n\u00e0o trong m\u1ed9t b\u1ea3ng t\u00ednh, chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1 th\u1eadp ph\u00e2n, t\u00ednh t\u1ed5ng c\u00e1c \u0111\u01a1n v\u1ecb th\u1eddi gian kh\u00e1c nhau ho\u1eb7c t\u00ednh th\u1eddi gian tr\u00f4i qua.<\/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-674d6a098b097\" 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\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Dinh_dang_thoi_gian_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel:\">\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian 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\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Lam_the_nao_de_co_duoc_mot_so_thap_phan_dai_dien_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Cach_ap_dung_hoac_thay_doi_dinh_dang_thoi_gian_trong_Excel\" title=\"C\u00e1ch \u00e1p d\u1ee5ng ho\u1eb7c thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel:\">C\u00e1ch \u00e1p d\u1ee5ng ho\u1eb7c thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng 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-4\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Tao_mot_dinh_dang_thoi_gian_tuy_chinh_trong_Excel\" title=\"T\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh trong Excel:\">T\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh trong Excel:<\/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\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Dinh_dang_tuy_chinh_trong_khoang_thoi_gian_tren_24_gio\" title=\"\u0110\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh trong kho\u1ea3ng th\u1eddi gian tr\u00ean 24 gi\u1edd:\">\u0110\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh trong kho\u1ea3ng th\u1eddi gian 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-6\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Dinh_dang_thoi_gian_tuy_chinh_cho_nhung_gia_tri_thoi_gian_am\" title=\"\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh cho nh\u1eefng gi\u00e1 tr\u1ecb th\u1eddi gian \u00e2m:\">\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh cho nh\u1eefng gi\u00e1 tr\u1ecb th\u1eddi gian \u00e2m:<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Dinh_dang_thoi_gian_mac_dinh_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh trong Excel:\">\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh trong Excel:<\/a><\/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\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Lam_the_nao_de_chen_thoi_gian_va_mot_moc_thoi_gian_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian v\u00e0 m\u1ed9t m\u1ed1c th\u1eddi gian trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian v\u00e0 m\u1ed9t m\u1ed1c 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-9\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Them_vao_moc_thoi_gian_bang_cac_phim_tat\" title=\"Th\u00eam v\u00e0o m\u1ed1c th\u1eddi gian b\u1eb1ng c\u00e1c ph\u00edm t\u1eaft:\">Th\u00eam v\u00e0o m\u1ed1c th\u1eddi gian b\u1eb1ng c\u00e1c ph\u00edm t\u1eaft:<\/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\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Them_ngay_thang_hien_tai_va_thoi_gian_hien_tai_bang_ham_NOW\" title=\"Th\u00eam ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i b\u1eb1ng h\u00e0m NOW\">Th\u00eam ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i b\u1eb1ng h\u00e0m NOW<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Chen_thoi_gian_hien_tai_lam_mot_gia_tri_dong\" title=\"Ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i l\u00e0m m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng\">Ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i l\u00e0m m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng<\/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\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Chen_thoi_gian_bang_ham_TIME\" title=\"Ch\u00e8n th\u1eddi gian b\u1eb1ng h\u00e0m TIME:\">Ch\u00e8n th\u1eddi gian b\u1eb1ng h\u00e0m TIME:<\/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-13\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html#Lam_the_nao_de_co_duoc_gio_phut_va_giay_tu_moc_thoi_gian\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y t\u1eeb m\u1ed1c th\u1eddi gian:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y t\u1eeb m\u1ed1c th\u1eddi gian:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thoi_gian_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 l\u00e0m theo h\u01b0\u1edbng d\u1eabn v\u1ec1 H\u01b0\u1edbng d\u1eabn v\u1ec1 Ng\u00e0y trong Excel c\u1ee7a ch\u00fang t\u00f4i, ch\u1eafc h\u1eb3n b\u1ea1n s\u1ebd bi\u1ebft r\u1eb1ng Microsoft Excel l\u01b0u tr\u1eef c\u00e1c ng\u00e0y nh\u01b0 c\u00e1c s\u1ed1 th\u1ee9 t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1 th\u00e1ng 1 n\u0103m 1900, d\u01b0\u1edbi d\u1ea1ng s\u1ed1 1. B\u1edfi v\u00ec Excel x\u1eed l\u00fd th\u1eddi gian nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a m\u1ed9t ng\u00e0y, \u0111\u1ed3ng th\u1eddi th\u00ec th\u1eddi gian \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng ph\u00e2n s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<p style=\"text-align: justify\"><strong>Trong h\u1ec7 th\u1ed1ng n\u1ed9i b\u1ed9 c\u1ee7a Excel:<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>00:00:00 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng 0.0<\/li>\n<li>23:59:59 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng 0.99999<\/li>\n<li>06:00 s\u00e1ng l\u00e0 0,25<\/li>\n<li>12:00 t\u1ed1i l\u00e0 0.5<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi c\u1ea3 ng\u00e0y v\u00e0 th\u1eddi gian \u0111\u1ec1u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4, th\u00ec ch\u00fang \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n bao g\u1ed3m ph\u1ea7n nguy\u00ean (\u0111\u1ea1i di\u1ec7n cho ng\u00e0y th\u00e1ng) v\u00e0 ph\u1ea7n s\u1ed1 th\u1eadp ph\u00e2n (\u0111\u1ea1i di\u1ec7n cho th\u1eddi gian). V\u00ed d\u1ee5: ng\u00e0y 1 th\u00e1ng 6 n\u0103m 2015 9:30:00 s\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef l\u00e0 42156.3958333333.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html\">H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng theo tu\u1ea7n, th\u00e1ng, n\u0103m<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_duoc_mot_so_thap_phan_dai_dien_trong_Excel\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch nhanh ch\u00f3ng \u0111\u1ec3 ch\u1ecdn m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n cho m\u1ed9t th\u1eddi gian c\u1ee5 th\u1ec3 l\u00e0 s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Format Cells.<\/p>\n<p style=\"text-align: justify\">M\u1ecdi th\u1ee9 kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ea5y. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a th\u1eddi gian v\u00e0 nh\u1ea5n Ctrl + 1 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells. Tr\u00ean tab Number, ch\u1ecdn General trong m\u1ee5c Category, v\u00e0 khi \u0111\u00f3 b\u1ea1n s\u1ebd th\u1ea5y th\u1eadp ph\u00e2n trong h\u1ed9p Samples.<\/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-84.gif\" title=\"vba101_92019-nho-84\"><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-197.gif\" title=\"ex101_92019-nho-197\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-decimal.png\" alt=\"Get a decimal representing the time in a cell\" title=\"excel-time-decimal\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 ghi l\u1ea1i con s\u1ed1 \u0111\u00f3 v\u00e0 nh\u1ea5p v\u00e0o Cancel \u0111\u1ec3 \u0111\u00f3ng c\u1eeda s\u1ed5. Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o n\u00fat OK v\u00e0 c\u00f3 th\u1eddi gian \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng s\u1ed1 th\u1eadp ph\u00e2n t\u01b0\u01a1ng \u1ee9ng trong \u00f4. Tr\u00ean th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 ngh\u0129 \u0111\u1ebfn n\u00f3 nh\u01b0 l\u00e0 c\u00e1ch nhanh nh\u1ea5t, d\u1ec5 d\u00e0ng nh\u1ea5t v\u00e0 kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh th\u1eadp ph\u00e2n trong Excel. Tuy nhi\u00ean, ch\u00fang t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u trong ph\u1ea7n ti\u1ebfp theo c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y, v\u00e0 khi \u0111\u00f3 ch\u00fang ta s\u1ebd c\u00f9ng xem x\u00e9t k\u1ef9 h\u01a1n c\u00e1c h\u00e0m v\u00e0 ph\u00e9p t\u00ednh th\u1eddi gian \u0111\u1eb7c bi\u1ec7t c\u00f3 kh\u1ea3 n\u0103ng chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian sang gi\u1edd, ph\u00fat ho\u1eb7c gi\u00e2y.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_ap_dung_hoac_thay_doi_dinh_dang_thoi_gian_trong_Excel\"><\/span>C\u00e1ch \u00e1p d\u1ee5ng ho\u1eb7c thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Microsoft Excel l\u00e0 \u0111\u1ee7 th\u00f4ng minh \u0111\u1ec3 nh\u1eadn ra m\u1ed9t th\u1eddi gian khi b\u1ea1n nh\u1eadp v\u00e0o v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 m\u1ed9t c\u00e1ch ph\u00f9 h\u1ee3p. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n nh\u1eadp 20:30, ho\u1eb7c 8:30 chi\u1ec1u ho\u1eb7c th\u1eadm ch\u00ed 8:30 trong m\u1ed9t \u00f4, Excel s\u1ebd gi\u1ea3i th\u00edch \u0111\u00e2y l\u00e0 m\u1ed9t kho\u1ea3ng th\u1eddi gian v\u00e0 hi\u1ec3n th\u1ecb v\u00e0o 20:30 ho\u1eb7c 8:30, t\u00f9y thu\u1ed9c v\u00e0o th\u1eddi gian m\u1eb7c \u0111\u1ecbnh m\u00e0 b\u1ea1n \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng m\u1ed9t v\u00e0i s\u1ed1 li\u1ec7u d\u01b0\u1edbi d\u1ea1ng th\u1eddi gian ho\u1eb7c \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian kh\u00e1c v\u1edbi gi\u00e1 tr\u1ecb th\u1eddi gian hi\u1ec7n t\u1ea1i, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i Format Cells, nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong m\u1ed9t trang Excel, ch\u1ecdn m\u1ed9t\/nh\u1eefng \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng hay thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian.<\/li>\n<li>M\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong> b\u1eb1ng c\u00e1ch nh\u1ea5n Ctrl + 1 ho\u1eb7c nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Dialog Box Launcher b\u1ebf b\u00ean Number trong nh\u00f3m <strong><em>Number<\/em><\/strong>, tr\u00ean <strong><em>tab Home<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/launch-format-cells-dialog.png\" alt=\"Click the Dialog Box Launcher to open the Format Cells dialog.\" title=\"launch-format-cells-dialog\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><strong><em>Tr\u00ean tab Number<\/em><\/strong>, ch\u1ecdn <strong><em>Time<\/em><\/strong> t\u1eeb m\u1ee5c <strong><em>Category<\/em><\/strong> v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian mong mu\u1ed1n t\u1eeb m\u1ee5c <strong><em>Type<\/em><\/strong>.<\/li>\n<li><strong><em>Nh\u1ea5n OK<\/em><\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian \u0111\u00e3 ch\u1ecdn v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-change-time-format.png\" alt=\"Applying or changing the time format in Excel\" title=\"excel-change-time-format\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_mot_dinh_dang_thoi_gian_tuy_chinh_trong_Excel\"><\/span>T\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 Microsoft Excel cung c\u1ea5p kh\u00e1 \u00edt c\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian kh\u00e1c nhau, nh\u01b0ng v\u1ea5n \u0111\u1ec1 l\u00e0 \u0111\u00f4i khi b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ri\u00eang m\u00ecnh ph\u00f9 h\u1ee3p nh\u1ea5t cho m\u1ed9t trang t\u00ednh c\u1ee5 th\u1ec3. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n h\u00e3y m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong> l\u00ean, ch\u1ecdn <strong><em>Custom<\/em><\/strong> t\u1eeb danh m\u1ee5c <strong><em>Category<\/em><\/strong> v\u00e0 g\u00f5 \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng trong h\u1ed9p <strong><em>Type.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-custom-time-format-excel.png\" alt=\"Creating a custom time format in Excel\" title=\"create-custom-time-format-excel\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh b\u1ea1n \u0111\u00e3 t\u1ea1o s\u1ebd n\u1eb1m trong m\u1ee5c <strong><em>Type <\/em><\/strong>v\u00e0 hi\u1ec3n th\u1ecb t\u1eeb sau l\u1ea7n ti\u1ebfp theo b\u1ea1n s\u1eed d\u1ee5ng.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-excel-co-loi-giai-phan-2.html\">Ba\u0300i t\u00e2\u0323p Excel co\u0301 l\u01a1\u0300i gia\u0309i (du\u0300ng ha\u0300m Vlookup, ha\u0300m IF) Ph\u00e2\u0300n 2<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">M\u00e1ch nh\u1ecf: C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh trong Excel l\u00e0 vi\u1ec7c s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng hi\u1ec7n t\u1ea1i \u0111\u1ec3 xu\u1ea5t ph\u00e1t. T\u01b0\u01a1ng \u1ee9ng v\u1edbi vi\u1ec7c, b\u1ea1n ph\u1ea3i nh\u1ea5p v\u00e0o <strong><em>Time<\/em><\/strong> trong m\u1ee5c <strong><em>Category<\/em><\/strong> v\u00e0 ch\u1ecdn m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc trong m\u1ee5c <strong><em>Type<\/em><\/strong>. Sau \u0111\u00f3 chuy\u1ec3n sang <strong><em>Custom<\/em><\/strong> v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c thay \u0111\u1ed5i cho \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb trong h\u1ed9p <strong><em>Type.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c m\u00e3 sau \u0111\u00e2y.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"144\"><strong>M\u00e3<\/strong><\/td>\n<td width=\"264\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td width=\"238\"><strong>\u0110\u1ec3 hi\u1ec7n th\u1ecb<\/strong><\/td>\n<\/tr>\n<tr>\n<td>h<\/td>\n<td>Gi\u1edd m\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 0 ph\u00eda tr\u01b0\u1edbc<\/td>\n<td>0-23<\/td>\n<\/tr>\n<tr>\n<td>hh<\/td>\n<td>Gi\u1edd c\u00f3 2 ch\u1eef s\u1ed1<\/td>\n<td>00-23<\/td>\n<\/tr>\n<tr>\n<td>m<\/td>\n<td>S\u1ed1 ph\u00fat m\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 0 ph\u00eda tr\u01b0\u1edbc<\/td>\n<td>0-59<\/td>\n<\/tr>\n<tr>\n<td>mm<\/td>\n<td>S\u1ed1 ph\u00fat c\u00f3 2 ch\u1eef s\u1ed1<\/td>\n<td>00-59<\/td>\n<\/tr>\n<tr>\n<td>s<\/td>\n<td>S\u1ed1 gi\u00e2y m\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 0 ph\u00eda tr\u01b0\u1edbc<\/td>\n<td>0-59<\/td>\n<\/tr>\n<tr>\n<td>ss<\/td>\n<td>S\u1ed1 gi\u00e2y c\u00f3 2 ch\u1eef s\u1ed1<\/td>\n<td>00-59<\/td>\n<\/tr>\n<tr>\n<td>AM\/PM<\/td>\n<td>Kho\u1ea3ng th\u1eddi gian trong ng\u00e0y (n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u00ec s\u1ebd m\u1eb7c \u0111\u1ecbnh s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng 24 gi\u1edd)<\/td>\n<td>AM or PM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">M\u00e1ch nh\u1ecf: \u0110\u1ec3 t\u1ea1o \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh cho ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian, h\u00e3y s\u1eed d\u1ee5ng v\u00e0 k\u1ebft h\u1ee3p th\u00f4ng minh c\u00e1c m\u00e3 th\u1eddi gian v\u00e0 m\u00e3 ng\u00e0y.<\/p>\n<p style=\"text-align: justify\">B\u1ea3ng sau \u0111\u00e2y cung c\u1ea5p m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch c\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong Excel c\u1ee7a b\u1ea1n:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"300\"><strong>\u0110\u1ecbnh d\u1ea1ng<\/strong><\/td>\n<td width=\"301\"><strong>\u0110\u1ec3 hi\u1ec3n th\u1ecb<\/strong><\/td>\n<\/tr>\n<tr>\n<td>h:mm:ss AM\/PM<\/td>\n<td>1:30:00 PM<\/td>\n<\/tr>\n<tr>\n<td>h:mm<\/td>\n<td>13:30<\/td>\n<\/tr>\n<tr>\n<td>dddd, m\/d\/yy h:mm AM\/PM<\/td>\n<td>Tuesday, 1\/13\/15 1:30 PM<\/td>\n<\/tr>\n<tr>\n<td>ddd, mmmm dd, yyyy hh:mm:ss<\/td>\n<td>Tue, January 13, 2015 13:30:00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_tuy_chinh_trong_khoang_thoi_gian_tren_24_gio\"><\/span>\u0110\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh trong kho\u1ea3ng th\u1eddi gian tr\u00ean 24 gi\u1edd:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi b\u1ea1n t\u00ednh to\u00e1n th\u1eddi gian trong Excel, m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a t\u1ed5ng l\u01b0\u1ee3ng th\u1eddi gian th\u00ec c\u00f3 th\u1ec3 v\u01b0\u1ee3t qu\u00e1 24 gi\u1edd. \u0110\u1ec3 Microsoft Excel hi\u1ec3n th\u1ecb th\u1eddi gian v\u01b0\u1ee3t qu\u00e1 24 gi\u1edd m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, h\u00e3y \u00e1p d\u1ee5ng m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh sau \u0111\u00e2y.<\/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 width=\"216\">[h]:mm<\/td>\n<td width=\"168\">41:30<\/td>\n<td width=\"198\">41 gi\u1edd v\u00e0 30 ph\u00fat<\/td>\n<\/tr>\n<tr>\n<td width=\"216\">[h]:mm:ss<\/td>\n<td width=\"168\">41:30:10<\/td>\n<td rowspan=\"2\" width=\"198\">41 gi\u1edd v\u00e0 30 ph\u00fat v\u00e0 10 gi\u00e2y<\/td>\n<\/tr>\n<tr>\n<td width=\"216\">[h] \u201chours\u201d, mm \u201cminutes\u201d, ss \u201cseconds\u201d<\/td>\n<td width=\"168\">40 gi\u1edd, 30 ph\u00fat, 10 gi\u00e2y<\/td>\n<\/tr>\n<tr>\n<td width=\"216\">d h:mm:ss<\/td>\n<td width=\"168\">1 17:30:10<\/td>\n<td rowspan=\"3\" width=\"198\">1 ng\u00e0y, 17 gi\u1edd, 30 ph\u00fat and 10 gi\u00e2y<\/td>\n<\/tr>\n<tr>\n<td width=\"216\">d \u201cday\u201d h:mm:ss<\/td>\n<td width=\"168\">1 ng\u00e0y 17:30:10<\/td>\n<\/tr>\n<tr>\n<td width=\"216\">d \u201cday,\u201d h \u201chours,\u201d m \u201cminutes and\u201d s \u201cseconds\u201d<\/td>\n<td width=\"168\">1 ng\u00e0y, 17 gi\u1edd, 30 ph\u00fat v\u00e0 10 gi\u00e2y<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thoi_gian_tuy_chinh_cho_nhung_gia_tri_thoi_gian_am\"><\/span>\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh cho nh\u1eefng gi\u00e1 tr\u1ecb th\u1eddi gian \u00e2m:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian t\u00f9y ch\u1ec9nh \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb mang d\u1ea5u d\u01b0\u01a1ng. N\u00ean n\u1ebfu k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n c\u1ee7a b\u1ea1n l\u00e0 gi\u00e1 tr\u1ecb \u00e2m (\u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi d\u1ea1ng th\u1eddi gian) (v\u00ed d\u1ee5: khi b\u1ea1n tr\u1eeb m\u1ed9t s\u1ed1 ti\u1ec1n l\u1edbn h\u01a1n t\u1eeb m\u1ed9t s\u1ed1 nh\u1ecf h\u01a1n), k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb l\u00e0 #####. C\u00f2n n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb th\u1eddi gian \u00e2m kh\u00e1c nhau, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Hi\u1ec3n th\u1ecb m\u1ed9t \u00f4 tr\u1ed1ng cho th\u1eddi gian \u00e2m. Nh\u1eadp d\u1ea5u ch\u1ea5m ph\u1ea9y v\u00e0o cu\u1ed1i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian, v\u00ed d\u1ee5 [h]: mm;<\/li>\n<li>Hi\u1ec3n th\u1ecb m\u1ed9t th\u00f4ng b\u00e1o l\u1ed7i. Nh\u1eadp d\u1ea5u ch\u1ea5m ph\u1ea9y v\u00e0o cu\u1ed1i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian, sau \u0111\u00f3 g\u00f5 m\u1ed9t th\u00f4ng b\u00e1o b\u1eb1ng d\u1ea5u nh\u00e1y k\u00e9p, v\u00ed d\u1ee5: [H]: mm, \u201cTh\u1eddi gian \u00e2m\u201d<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u00f3i chung, d\u1ea5u ch\u1ea5m ph\u1ea9y \u0111\u00f3ng vai tr\u00f2 l\u00e0 d\u1ea5u ph\u00e2n t\u00e1ch \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u1ecbnh d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb mang d\u1ea5u d\u01b0\u01a1ng v\u00e0 \u0111\u1ecbnh d\u1ea1ng \u00a0c\u00e1c gi\u00e1 tr\u1ecb mang d\u1ea5u \u00e2m.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb th\u1eddi gian mang gi\u00e1 tr\u1ecb \u00e2m, v\u00ed d\u1ee5: -10: 30, th\u00ec c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 thay \u0111\u1ed5i h\u1ec7 th\u1ed1ng ng\u00e0y th\u00e1ng c\u1ee7a Excel sang h\u1ec7 th\u1ed1ng ng\u00e0y 1904. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o <strong><em>File&gt;Options&gt;Advanced<\/em><\/strong>, k\u00e9o xu\u1ed1ng <strong><em>When calculating this workbook section<\/em><\/strong> (Khi t\u00ednh to\u00e1n ph\u1ea7n n\u00e0y trong b\u1ea3ng t\u00ednh) v\u00e0 ki\u1ec3m tra <strong><em>h\u1ed9p Use 1904 date system<\/em><\/strong> (s\u1eed d\u1ee5ng h\u1ec7 th\u1ed1ng ng\u00e0y n\u0103m 1904)<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thoi_gian_mac_dinh_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong h\u1ed9p tho\u1ea1i Format Cells, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y r\u1eb1ng c\u00f3 m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng n\u00e0y b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u hoa th\u1ecb (*). \u0110\u00e2y l\u00e0 \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh trong Excel c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-default-time-format.png\" alt=\"The default time format in Excel\" title=\"excel-default-time-format\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 nhanh ch\u00f3ng \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel v\u00e0o \u00f4 ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4 \u0111\u00e3 ch\u1ecdn, h\u00e3y nh\u1ea5p v\u00e0o m\u0169i t\u00ean th\u1ea3 xu\u1ed1ng trong nh\u00f3m Number, tr\u00ean tab Home v\u00e0 ch\u1ecdn m\u1ee5c <strong><em>Time.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/apply-default-excel-time-format.png\" alt=\"A quick way to apply the default time format in Excel\" title=\"apply-default-excel-time-format\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1eb7c \u0111\u1ecbnh, b\u1ea1n v\u00e0o Control Panel v\u00e0 nh\u1ea5p Region and Language. N\u1ebfu trong b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n c\u1ee7a b\u1ea1n m\u1edf \u1edf <strong><em>ch\u1ebf \u0111\u1ed9 xem Category, h\u00e3y nh\u1ea5p v\u00e0o Clock, Language, and Region&gt; Region and Language&gt; Change the date, time, or number format.<\/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\/change-default-excel-time-format.png\" alt=\"Changing the default time format\" title=\"change-default-excel-time-format\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: Khi b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian m\u1edbi c\u1ee7a Excel ho\u1eb7c mu\u1ed1n s\u1eeda \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng hi\u1ec7n t\u1ea1i, h\u00e3y nh\u1edb r\u1eb1ng b\u1ea5t k\u1ec3 b\u1ea1n \u0111\u00e3 ch\u1ecdn c\u00e1ch n\u00e0o \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u1eddi gian trong m\u1ed9t \u00f4, th\u00ec Excel lu\u00f4n lu\u00f4n l\u01b0u tr\u1eef n\u1ed9i b\u1ed9 c\u00e1c th\u1eddi gian v\u1edbi c\u00f9ng m\u1ed9t c\u00e1ch \u2013 b\u1eb1ng c\u00e1c ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_chen_thoi_gian_va_mot_moc_thoi_gian_trong_Excel\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian v\u00e0 m\u1ed9t m\u1ed1c th\u1eddi gian trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f3 nhi\u1ec1u \u0111\u1ec3 ch\u00e8n th\u1eddi gian v\u00e0o Excel, nh\u01b0ng vi\u1ec7c b\u1ea1n s\u1eed d\u1ee5ng c\u00e1i n\u00e0o th\u00ec c\u00f2n t\u00f9y thu\u1ed9c v\u00e0o vi\u1ec7c b\u1ea1n mu\u1ed1n c\u00f3 m\u1ed9t m\u1ed1c th\u1eddi gian c\u1ed1 \u0111\u1ecbnh hay m\u1ed9t gi\u00e1 tr\u1ecb thay \u0111\u1ed5i (m\u00e0 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng \u0111\u1ec3 cho th\u1ea5y th\u1eddi gian hi\u1ec7n t\u1ea1i).<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Them_vao_moc_thoi_gian_bang_cac_phim_tat\"><\/span>Th\u00eam v\u00e0o m\u1ed1c th\u1eddi gian b\u1eb1ng c\u00e1c ph\u00edm t\u1eaft:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t c\u00e1ch \u0111\u1ec3 ch\u00e8n m\u1ed1c th\u1eddi gian v\u00e0o \u00f4 Excel, t\u1ee9c l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb t\u0129nh (kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u00f9 cho b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh l\u1ea1i), h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c ph\u00edm t\u1eaft sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i, nh\u1ea5n <strong><em>Ctrl + Shift +;<\/em><\/strong><\/li>\n<li>Ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i: Nh\u1eadp ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i, nh\u1ea5n <strong><em>Ctrl +;<\/em><\/strong> \u0111\u1ec3 ch\u00e8n m\u1ed9t ng\u00e0y, sau \u0111\u00f3 b\u1ea5m ph\u00edm<strong><em> Space<\/em><\/strong> (ph\u00edm c\u00e1ch), r\u1ed3i nh\u1ea5n <strong><em>Ctrl + Shift +;<\/em><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-timestamp-excel.png\" alt=\"Inset a timestamp in Excel using shortcuts\" title=\"insert-timestamp-excel\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Them_ngay_thang_hien_tai_va_thoi_gian_hien_tai_bang_ham_NOW\"><\/span>Th\u00eam ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0 th\u1eddi gian hi\u1ec7n t\u1ea1i b\u1eb1ng h\u00e0m NOW<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 ch\u00e8n ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i \u0111\u1ec3 l\u00e0m m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng (t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt), h\u00e3y s\u1eed d\u1ee5ng h\u00e0m NOW trong Excel.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u01b0 n\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c ghi nh\u01b0 sau: (kh\u00f4ng c\u00f3 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c)<\/p>\n<p style=\"text-align: justify\"><strong><em>= NOW ()<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng h\u00e0m NOW trong Excel, c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd:<\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e0m NOW truy xu\u1ea5t th\u1eddi gian t\u1eeb \u0111\u1ed3ng h\u1ed3 h\u1ec7 th\u1ed1ng c\u1ee7a m\u00e1y t\u00ednh.<\/li>\n<li>H\u00e0m NOW l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m d\u1ec5 thay \u0111\u1ed5i trong Excel, ngh\u0129a l\u00e0 c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec1u s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh m\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c m\u1edf l\u1ea1i ho\u1eb7c t\u00ednh l\u1ea1i.<\/li>\n<li>\u0110\u1ec3 bu\u1ed9c h\u00e0m NOW c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1, nh\u1ea5n Shift + F9 \u0111\u1ec3 t\u00ednh to\u00e1n l\u1ea1i b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i ho\u1eb7c F9 \u0111\u1ec3 t\u00ednh to\u00e1n l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh \u0111ang m\u1edf.<\/li>\n<li>\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c h\u00e0m NOW t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt trong kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh, h\u00e3y th\u00eam m\u1ed9t macro VBA v\u00e0o b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f3 s\u1eb5n \u1edf \u0111\u00e2y.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_thoi_gian_hien_tai_lam_mot_gia_tri_dong\"><\/span>Ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i l\u00e0m m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0o \u00f4 m\u00e0 kh\u00f4ng ch\u00e8n ng\u00e0y, th\u00ec d\u01b0\u1edbi \u0111\u00e2y c\u00f3c\u00e1c l\u1ef1a ch\u1ecdn \u0111\u1ec3 b\u1ea1n tham kh\u1ea3o:<\/p>\n<ol style=\"text-align: justify\">\n<li>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <strong><em>= NOW (),<\/em><\/strong> v\u00e0 sau \u0111\u00f3 \u00e1p d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian trong 1 hay nhi\u1ec1u \u00f4.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb, \u0111i\u1ec1u n\u00e0y s\u1ebd ch\u1ec9 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb, gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong m\u1ed9t \u00f4 v\u1eabn s\u1ebd l\u00e0 m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n g\u1ed3m ph\u1ea7n nguy\u00ean \u0111\u1ea1i di\u1ec7n cho ng\u00e0y v\u00e0 ph\u1ea7n th\u1eadp ph\u00e2n th\u1ec3 hi\u1ec7n th\u1eddi gian.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau<strong><em>: = NOW () \u2013 INT (NOW ())<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">H\u00e0m INT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi NOW () xu\u1ed1ng s\u1ed1 nguy\u00ean g\u1ea7n n\u00f3 nh\u1ea5t. V\u00e0 sau \u0111\u00f3, b\u1ea1n tr\u1eeb \u0111i ph\u1ea7n nguy\u00ean \u0111\u1ea1i di\u1ec7n cho ng\u00e0y h\u00f4m nay \u0111\u1ec3 ch\u1ec9 ra ph\u1ea7n th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n cho th\u1eddi gian hi\u1ec7n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\">V\u00ec c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 l\u00e0 d\u1ea1ng th\u1eadp ph\u00e2n, n\u00ean b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian v\u00e0o c\u00e1c \u00f4 khi\u1ebfn gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng th\u1eddi gian.<\/p>\n<p style=\"text-align: justify\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau minh h\u1ecda c\u1ea3 hai c\u00f4ng th\u1ee9c tr\u00ean. Ch\u00fa \u00fd r\u1eb1ng d\u00f9 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian gi\u1ed1ng nhau (c\u1ed9t C), th\u00ec c\u00e1c gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong c\u00e1c \u00f4 (c\u1ed9t D) v\u1eabn kh\u00e1c nhau \u2013 D4 ch\u1ec9 ch\u1ee9a ph\u1ea7n th\u1eadp ph\u00e2n:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-now-function-return-time.png\" alt=\"Inserting the current time as a dynamic value\" title=\"excel-now-function-return-time\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_thoi_gian_bang_ham_TIME\"><\/span>Ch\u00e8n th\u1eddi gian b\u1eb1ng h\u00e0m TIME:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m TIME trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n hi\u1ec3n th\u1ecb th\u1eddi gian th\u00e0nh m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ea1i di\u1ec7n cho th\u1eddi gian.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Excel TIME r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n<p style=\"text-align: justify\"><strong><em>= TIME (hour,minute,second)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c \u0111\u1ed1i s\u1ed1 hour (gi\u1edd), minute (ph\u00fat) v\u00e0 second (gi\u00e2y) c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o d\u01b0\u1edbi d\u1ea1ng s\u1ed1 t\u1eeb 0 \u0111\u1ebfn 3276.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu hour l\u1edbn h\u01a1n 23, th\u00ec n\u00f3 s\u1ebd chia cho 24 v\u00e0 ph\u1ea7n c\u00f2n l\u1ea1i s\u1ebd \u0111\u01b0\u1ee3c l\u1ea5y l\u00e0m gi\u00e1 tr\u1ecb gi\u1edd.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, TIME (30, 0, 0) t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi TIME(6,0,0), \u0111\u1ec1u l\u00e0 0,25 ho\u1eb7c 6 gi\u1edd s\u00e1ng<\/p>\n<p style=\"text-align: justify\">N\u1ebfu minute l\u1edbn h\u01a1n 59, n\u00f3 \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh gi\u1edd v\u00e0 ph\u00fat. V\u00e0 n\u1ebfu second l\u1edbn h\u01a1n 59, th\u00ec chuy\u1ec3n th\u00e0nh gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, TIME (0, 930, 0) \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh TIME (15, 30, 0), \u0111\u1ec1u l\u00e0 0,645833333 ho\u1eb7c 15:30.<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c s\u1ef1 th\u00ec h\u00e0m TIME r\u1ea5t h\u1eefu \u00edch khi k\u1ebft h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang l\u1ebb v\u00e0o m\u1ed9t gi\u00e1 tr\u1ecb th\u1eddi gian \u0111\u01a1n, v\u00ed d\u1ee5 gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 kh\u00e1c ho\u1eb7c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c h\u00e0m Excel kh\u00e1c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-time-function.png\" alt=\"Inserting time using the Excel TIME function\" title=\"excel-time-function\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_duoc_gio_phut_va_giay_tu_moc_thoi_gian\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y t\u1eeb m\u1ed1c th\u1eddi gian:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u1ea5y ra \u0111\u01b0\u1ee3c t\u1eebng \u0111\u01a1n v\u1ecb th\u1eddi gian trong m\u1ed1c th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m c\u00f4ng th\u1ee9c th\u1eddi gian nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong><em>HOUR(serial_number)<\/em><\/strong><strong><em>\u00a0\u2013<\/em><\/strong> tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb gi\u1edd c\u1ee7a th\u1eddi gian \u0111\u00f3, \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean ch\u1ea1y t\u1eeb 0 (12:00 s\u00e1ng) \u0111\u1ebfn 23 (11:00 t\u1ed1i)<\/p>\n<p style=\"text-align: justify\"><strong><em>MINUTE(serial_number)<\/em><\/strong><strong><em>\u00a0\u2013<\/em><\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 ph\u00fat trong gi\u00e1 tr\u1ecb th\u1eddi gian \u0111\u00f3, c\u00f3 d\u1ea1ng l\u00e0 1 s\u1ed1 nguy\u00ean c\u00f3 gi\u00e1 tr\u1ecb trong kho\u1ea3ng t\u1eeb 0 \u0111\u1ebfn 59.<\/p>\n<p style=\"text-align: justify\"><em>SECOND(serial_number<\/em><em>)<\/em> \u2013 tr\u1ea3 v\u1ec1 s\u1ed1 gi\u00e2y trong gi\u00e1 tr\u1ecb th\u1eddi gian \u0111\u00f3, l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean c\u00f3 gi\u00e1 tr\u1ecb trong kho\u1ea3ng t\u1eeb 0 \u0111\u1ebfn 59.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-thoi-gian-thong-dung-trong-excel.html\">H\u00e0m th\u1eddi gian th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong c\u1ea3 3 c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u th\u1eddi gian \u1edf d\u1ea1ng chu\u1ed7i v\u00e0 \u0111\u1eb7t n\u00f3 trong d\u1ea5u nh\u00e1t k\u00e9p (v\u00ed d\u1ee5, \u201c6:00 s\u00e1ng\u201d), ho\u1eb7c d\u01b0\u1edbi d\u1ea1ng ph\u00e2n s\u1ed1 (v\u00ed d\u1ee5, 0.25 c\u00f3 ngh\u0129a l\u00e0 6:00 s\u00e1ng), hay l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a c\u00e1c h\u00e0m Excel kh\u00e1c. B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam 1 v\u00e0i c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 \u1edf d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong><em>=HOUR(A2)\u00a0<\/em><\/strong><strong><em>\u2013 <\/em><\/strong><em>tr\u1ea3 v\u1ec1 s\u1ed1 gi\u1edd trong m\u1ed1c th\u1eddi gian \u1edf \u00f4 A1<\/em><\/li>\n<li><strong><em>=MINUTE(A2)\u00a0<\/em><\/strong><strong><em>\u2013 <\/em><\/strong><em>tr\u1ea3 v\u1ec1 s\u1ed1 ph\u00fat trong m\u1ed1c th\u1eddi gian \u1edf \u00f4 A1<\/em><\/li>\n<li><strong><em>=SECOND(A2)\u00a0<\/em><\/strong><strong><em>\u2013 <\/em><\/strong><em>tr\u1ea3 v\u1ec1 s\u1ed1 gi\u00e2y trong m\u1ed1c th\u1eddi gian \u1edf \u00f4 A1<\/em><\/li>\n<li><strong><em>=HOUR(NOW())\u00a0<\/em><\/strong><strong><em>\u2013 <\/em><\/strong><em>tr\u1ea3 v\u1ec1 gi\u1edd hi\u1ec7n t\u1ea1i<\/em><\/li>\n<\/ul>\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-time-units.png\" alt=\"Getting hours, minutes and seconds from a timestamp\" title=\"extract-time-units\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, sau khi b\u1ea1n \u0111\u00e3 hi\u1ec3u v\u1ec1 c\u00e1c \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian v\u00e0 c\u00e1c h\u00e0m th\u1eddi gian trong Excel, th\u00ec n\u00f3 h\u1eb3n l\u00e0 d\u1ec5 d\u00e0ng h\u01a1n nhi\u1ec1u cho b\u1ea1n \u0111\u1ec3 thao t\u00e1c ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian trong b\u1ea3ng t\u00ednh. Trong ph\u1ea7n ti\u1ebfp theo c\u1ee7a h\u01b0\u1edbng d\u1eabn v\u1ec1 th\u1eddi gian trong Excel c\u1ee7a ch\u00fang t\u00f4i, ch\u00fang ta s\u1ebd c\u00f9ng th\u1ea3o lu\u1eadn c\u00e1c c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh s\u1ed1. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 hy v\u1ecdng \u0111\u01b0\u1ee3c g\u1eb7p b\u1ea1n tr\u00ean blog c\u1ee7a ch\u00fang t\u00f4i v\u00e0o tu\u1ea7n t\u1edbi!<\/p>\n<p style=\"text-align: justify\">\u2014\u2014\u2014<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026 Khi k\u1ebft h\u1ee3p t\u1ed1t c\u00e1c h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 v\u1edbi nhau th\u00ec b\u1ea1n s\u1ebd th\u1ea5y hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c tr\u00ean Excel s\u1ebd \u0111\u01b0\u1ee3c c\u1ea3i thi\u1ec7n r\u1ea5t nhi\u1ec1u.<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<\/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-84.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2548,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2547","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\/2547","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=2547"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2547\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2548"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}