{"id":12199,"date":"2022-11-22T21:29:58","date_gmt":"2022-11-22T14:29:58","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12199"},"modified":"2022-12-08T14:25:15","modified_gmt":"2022-12-08T07:25:15","slug":"ham-thoi-gian-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/","title":{"rendered":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12199&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng excel, b\u1ea1n ch\u1eafc ch\u1eafn s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng t\u1edbi c\u00e1c h\u00e0m th\u1eddi gian \u0111\u1ec3 ho\u00e0n th\u00e0nh m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c \u0111\u1eb7c th\u00f9. \u0110\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi, c\u00f4ng vi\u1ec7c n\u00e0y kh\u00e1 kh\u00f3 kh\u0103n khi h\u1ecd ch\u01b0a c\u00f3 trong tay th\u00f4ng tin v\u1ec1 ch\u00fang. V\u1eady c\u1ee5 th\u1ec3 <\/span><b>H\u00e0m th\u1eddi gian trong excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 g\u00ec? H\u00e3y c\u00f9ng nhau t\u00ecm hi\u1ec3u trong ph\u1ea7n ph\u00e2n t\u00edch ngay sau \u0111\u00e2y.\u00a0<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#Cac_ham_thoi_gian_trong_excel\" >C\u00e1c h\u00e0m th\u1eddi gian trong excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#Khai_niem_ham_time_trong_excel\" >Kh\u00e1i ni\u1ec7m h\u00e0m time trong excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#Ham_now_trong_excel\" >H\u00e0m now trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#Ham_thoi_gian_hour_minute_va_second_trong_excel\" >H\u00e0m th\u1eddi gian hour, minute v\u00e0 second trong excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#Cong_thuc_tinh_thoi_gian_chenh_lech_trong_excel\" >C\u00f4ng th\u1ee9c t\u00ednh th\u1eddi gian ch\u00eanh l\u1ec7ch trong excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#Ket_luan\" >K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_ham_thoi_gian_trong_excel\"><\/span><b>C\u00e1c h\u00e0m th\u1eddi gian trong excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c h\u00e0m time trong excel \u0111\u00e3 tr\u1edf n\u00ean qu\u00e1 ph\u1ed5 bi\u1ebfn v\u00e0 c\u1ea7n thi\u1ebft \u0111\u1ed1i v\u1edbi ch\u00fang ta khi s\u1eed d\u1ee5ng excel. \u0110\u1eb7c bi\u1ec7t n\u00f3 l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c cho nh\u1eefng ai l\u00e0m vi\u1ec7c t\u1ea1i v\u0103n ph\u00f2ng; nh\u01b0 k\u1ebf to\u00e1n, th\u01b0 k\u00fd&#8230; Ch\u00ednh v\u00ec v\u1eady, vi\u1ec7c n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c <\/span><b>c\u00e1c h\u00e0m th\u1eddi gian trong excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 c\u1ef1c k\u1ef3 c\u1ea5p thi\u1ebft. V\u1eady n\u00ean, ch\u00fang ta c\u00f2n ch\u1ea7n ch\u1edd g\u00ec n\u1eefa, h\u00e3y c\u00f9ng nhau t\u00ecm hi\u1ec3u v\u1ec1 lo\u1ea1i h\u00e0m n\u00e0y ngay sau \u0111\u00e2y nh\u00e9.\u00a0<\/span><\/p>\n<figure id=\"attachment_12392\" aria-describedby=\"caption-attachment-12392\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12392 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-3.jpg\" alt=\"C\u00e1c h\u00e0m time trong excel\" width=\"600\" height=\"414\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-3-400x276.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12392\" class=\"wp-caption-text\">C\u00e1c h\u00e0m time trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Khai_niem_ham_time_trong_excel\"><\/span><b>Kh\u00e1i ni\u1ec7m h\u00e0m time trong excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m time m\u1ed9t trong nh\u1eefng h\u00e0m th\u1eddi gian c\u01a1 b\u1ea3n v\u00e0 th\u00f4ng d\u1ee5ng nh\u1ea5t trong excel. Vi\u1ec7c b\u1ea1n bi\u1ebft v\u1ec1 c\u00e1c ch\u1ee9c n\u0103ng c\u0169ng nh\u01b0 c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng s\u1ebd r\u1ea5t t\u1ed1t cho m\u1ecdi c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. Sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd cung c\u1ea5p cho b\u1ea1n c\u00f4ng th\u1ee9c t\u00ednh h\u00e0m time. C\u1ee5 th\u1ec3, c\u00f4ng t\u00ednh t\u00ednh h\u00e0m time <\/span><span style=\"font-weight: 400;\">\u00a0= TIME( hour, minute, second).<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"To\u00e0n b\u1ed9 c\u00e1c c\u00e1ch t\u00ednh th\u1eddi gian th\u00f4ng d\u1ee5ng trong Excel (c\u1ea7n ph\u1ea3i bi\u1ebft)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/SUJad5MzTxM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, m\u1ed7i gi\u00e1 tr\u1ecb c\u00f3 m\u1ed9t \u00fd ngh\u0129a kh\u00e1c nhau, c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ee9 nh\u1ea5t, v\u1ec1 Hour, \u0111\u00e2y ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb gi\u1edd, l\u00e0 m\u1ed9t s\u00f4\u0301 trong t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 t\u1eeb 0 \u0111\u00ea\u0301n 32767.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Minute \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0\u00a0 gi\u00e1 tr\u1ecb ph\u00fat; t\u01b0\u01a1ng t\u1ef1 nh\u01b0 hour th\u00ec minute c\u0169ng l\u00e0 m\u1ed9t s\u00f4\u0301 t\u1eeb 0 \u0111\u00ea\u0301n 32767.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u00a0Cu\u1ed1i c\u00f9ng l\u00e0 Second ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb gi\u00e2y. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 hai gi\u00e1 tr\u1ecb tr\u00ean mintue s\u1ebd n\u1eb1m trong kho\u1ea3ng gi\u00e1 tr\u1ecb t\u1eeb\u00a0 0 \u0111\u00ea\u0301n 32767.\u00a0<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_now_trong_excel\"><\/span><b>H\u00e0m now trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_12393\" aria-describedby=\"caption-attachment-12393\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12393 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-4.jpg\" alt=\"H\u00e0m now trong excel\" width=\"600\" height=\"374\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-4-400x249.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12393\" class=\"wp-caption-text\">H\u00e0m now trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i h\u00e0m time, th\u00ec h\u00e0m now c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng <\/span><b>h\u00e0m th\u1eddi gian trong excel <\/b><span style=\"font-weight: 400;\">th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. C\u1ee5 th\u1ec3 h\u00e0m now ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb th\u1ec3 hi\u1ec7n th\u1eddi gian hi\u1ec7n t\u1ea1i c\u1ee7a h\u1ec7 th\u1ed1ng. \u0110i\u1ec1u n\u00e0y \u0111\u1ed3ng ngh\u0129a v\u1edbi vi\u1ec7c, khi s\u1eed d\u1ee5ng h\u00e0m now trong b\u1ea5t c\u1ee9 \u00f4 n\u00e0o; th\u00ec th\u1eddi gian s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 th\u1eddi gian th\u1ef1c t\u1ebf c\u1ee7a h\u1ec7 th\u1ed1ng khi \u0111\u00f3. C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m now l\u00e0 <\/span><span style=\"font-weight: 400;\">=NOW()<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_thoi_gian_hour_minute_va_second_trong_excel\"><\/span><b>H\u00e0m th\u1eddi gian hour, minute v\u00e0 second trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_12389\" aria-describedby=\"caption-attachment-12389\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12389 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-e1648131671824.jpg\" alt=\"H\u00e0m minute trong excel\" width=\"600\" height=\"256\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-e1648131671824.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-e1648131671824-400x171.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12389\" class=\"wp-caption-text\">H\u00e0m minute trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 \u0111\u00e3 n\u00f3i t\u1ea1i ph\u1ea7n h\u00e0m time, b\u1ea1n \u0111\u00e3 bi\u1ebft v\u1ec1 \u00fd ngh\u0129a c\u1ee7a c\u00e1c t\u1eeb hour, minute v\u00e0 second r\u1ed3i ph\u1ea3i kh\u00f4ng \u1ea1. \u0110\u00fang nh\u01b0 v\u1eady, t\u1ea1i h\u00e0m th\u1eddi gian n\u00e0y ch\u00fang v\u1eabn c\u00f3 \u00fd ngh\u0129a t\u01b0\u01a1ng t\u1ef1 nh\u01b0 t\u1ea1i h\u00e0m time.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3 t\u1ea1i h\u00e0m hour, minute v\u00e0 second s\u1ebd gi\u00fap b\u1ea1n tr\u1ea3 k\u1ebft qu\u1ea3 v\u1ec1 gi\u1edd, ph\u00fat, gi\u00e2y trong th\u1eddi gian; thay v\u00ec s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong b\u1ea1n ph\u1ea3i d\u00f9ng h\u00e0m HOUR, MINUTE, SECOND. N\u00f3i kh\u00e1i qu\u00e1t h\u01a1n, th\u00ec h\u00e0m hour s\u1ebd gi\u00fap b\u1ea1n tr\u1ea3 \u0111\u00fang k\u1ebft v\u1ec1 gi\u00e1 tr\u1ecb gi\u1edd; h\u00e0m minute tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 ph\u00fat v\u00e0 cu\u1ed1i c\u00f9ng second h\u1ed7 tr\u1ee3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb gi\u00e2y. V\u1edbi c\u00e1c c\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 sau: =HOUR(), h\u00e3y l\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady \u0111\u1ed1i v\u1edbi minute v\u00e0 second. B\u1ea1n ch\u1ec9 c\u1ea7n thay th\u1ebf hour trong c\u00f4ng th\u1ee9c b\u1eb1ng minute ho\u1eb7c second theo nhu c\u1ea7u c\u1ee7a b\u1ea1n.<\/span><\/p>\n<figure id=\"attachment_12394\" aria-describedby=\"caption-attachment-12394\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12394 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-5-e1648131718621.jpg\" alt=\"C\u00f4ng th\u1ee9c h\u00e0m Hour trong excel\" width=\"600\" height=\"258\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-5-e1648131718621.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-5-e1648131718621-400x172.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12394\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c h\u00e0m Hour trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y, l\u00e0 to\u00e0n b\u1ed9 c\u00e1c lo\u1ea1i<\/span><b> h\u00e0m th\u1eddi gian trong excel<\/b><span style=\"font-weight: 400;\"> b\u1ea1n c\u1ea7n n\u1eafm v\u1eefng; \u0111\u1ec3 c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh t\u1ed1t nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao c\u1ee7a b\u1ea3n th\u00e2n. \u0110\u00e2y s\u1ebd l\u00e0 c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c trong c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. V\u1eady n\u00ean h\u00e3y b\u1ecf t\u00fai nh\u1eefng b\u00ed k\u00edp n\u00e0y nh\u00e9. B\u1ea1n ch\u1ec9 c\u1ea7n b\u1ecf ra v\u00e0i ph\u00fat \u0111\u1ec3 \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y; th\u00ec \u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 \u0111\u01b0\u1ee3c c\u00e1c <\/span><b>h\u00e0m th\u1eddi gian trong excel<\/b><span style=\"font-weight: 400;\"> r\u1ed3i.<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/cach-hien-thanh-cong-cu-trong-excel\/\">C\u00e1ch hi\u1ec7n thanh c\u00f4ng c\u1ee5 trong excel kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/a><\/p>\n<p><a href=\"https:\/\/teky.edu.vn\/blog\/ham-xoa-ky-tu-trong-excel\/\">H\u00e0m x\u00f3a k\u00fd t\u1ef1 trong excel th\u01b0\u1eddng d\u00f9ng l\u00e0 nh\u1eefng lo\u1ea1i n\u00e0o?<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_thoi_gian_chenh_lech_trong_excel\"><\/span><b>C\u00f4ng th\u1ee9c t\u00ednh th\u1eddi gian ch\u00eanh l\u1ec7ch trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c t\u00ecm hi\u1ec3u c\u00e1c <\/span><b>h\u00e0m th\u1eddi gian<\/b><span style=\"font-weight: 400;\"> nh\u01b0 \u0111\u00e3 n\u00eau \u1edf tr\u00ean. B\u1ea1n c\u0169ng c\u1ea7n quan t\u00e2m t\u1edbi <\/span><b>h\u00e0m \u0111i\u1ec1u ki\u1ec7n th\u1eddi gian trong excel;<\/b><span style=\"font-weight: 400;\"> hay ch\u00ednh l\u00e0 <a href=\"https:\/\/vi.wikipedia.org\/wiki\/C%C3%B4ng_th%E1%BB%A9c\">c\u00f4ng th\u1ee9c<\/a> t\u00ednh th\u1eddi gian ch\u00eanh l\u1ec7ch trong excel.\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u1eeb th\u1eddi gian: C\u00f3 l\u1ebd \u0111\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng thao t\u00e1c ph\u1ed5 bi\u1ebfn; khi b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m th\u1eddi gian ph\u1ea3i kh\u00f4ng \u1ea1. \u0110\u1eb7c bi\u1ec7t v\u1edbi c\u00f4ng th\u1ee9c tr\u1eeb th\u1eddi gian c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n th\u1ef1c hi\u1ec7n tr\u1eeb th\u1eddi gian m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, ch\u1ec9 v\u1edbi c\u00f4ng th\u1ee9c: =End time \u2013 Start time.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u00ednh gi\u1edd, gi\u00e2y, ph\u00fat gi\u1eefa hai kho\u1ea3ng th\u1eddi gian: T\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean; \u0111\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u n\u00e0y b\u1ea1n ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng \u0111\u00fang c\u00f4ng th\u1ee9c c\u1ee7a n\u00f3. C\u1ee5 th\u1ec3 nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u00f3 l\u00e0: \u0110\u1ec3 t\u00ednh s\u1ed1 gi\u1edd gi\u1eefa hai th\u1eddi gian: =(End time \u2013 Start time) * 24. C\u00f2n v\u1edbi t\u1ed5ng s\u1ed1 ph\u00fat gi\u1eefa hai th\u1eddi gian: =(End time \u2013 Start time) * 1440. V\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 c\u00e1ch t\u00ednh t\u1ed5ng s\u1ed1 gi\u00e2y gi\u1eefa hai th\u1eddi gian: =(End time \u2013 Start time) * 8640.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh th\u1eddi gian tr\u00f4i qua k\u1ec3 t\u1eeb khi b\u1ea1n b\u1eaft \u0111\u1ea7u t\u00ednh \u0111\u1ebfn b\u00e2y gi\u1edd<\/span><b><i>: <\/i><\/b><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 b\u1ea1n ph\u1ea3i \u00e1p d\u1ee5ng <\/span><b>c\u00e1c h\u00e0m th\u1eddi gian trong Excel<\/b><span style=\"font-weight: 400;\">. M\u00e0 c\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0 h\u00e0m NOW. B\u1ea1n ch\u1ec9 c\u1ea7n l\u1ea5y h\u00e0m th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i tr\u1eeb \u0111i th\u1eddi \u0111i\u1ec3m tr\u01b0\u1edbc \u0111\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ed9ng th\u1eddi gian trong excel: \u0110\u1ec3 th\u1ef1c hi\u1ec7n <\/span><b>h\u00e0m c\u1ed9ng th\u1eddi gian trong excel; <\/b><span style=\"font-weight: 400;\">\u00e1p d\u1ee5ng khi b\u1ea1n mu\u1ed1n c\u1ed9ng th\u1eddi gian h\u01a1n 24 gi\u1edd: = th\u1eddi \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u + [N\/1440].<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_12390\" aria-describedby=\"caption-attachment-12390\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12390 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-1-e1648131881996.jpg\" alt=\" C\u00f4ng th\u1ee9c h\u00e0m Second trong excel\" width=\"600\" height=\"240\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-1-e1648131881996.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-1-e1648131881996-400x160.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12390\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c h\u00e0m Second trong excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1ec9 c\u1ea7n b\u1ecf ra m\u1ed9t th\u1eddi gian r\u1ea5t ng\u1eafn \u0111\u1ec3 t\u00ecm hi\u1ec3u; b\u1ea1n \u0111\u00e3 c\u00f3 ngay trong tay nh\u1eefng c\u00f4ng th\u1ee9c h\u1eefu \u00edch trong qu\u00e1 tr\u00ecnh t\u00ednh th\u1eddi gian ch\u00eanh l\u1ec7ch trong excel. V\u1eady n\u00ean, b\u1ea1n h\u00e3y b\u1ecf t\u00fai nh\u1eefng b\u00ed k\u00edp h\u1ed7 tr\u1ee3 vi\u1ec7c t\u00ednh to\u00e1n n\u00e0y nha.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00e0i ph\u00e2n t\u00edch tr\u00ean ch\u00fang t\u00f4i \u0111\u00e3 mang t\u1edbi nh\u1eefng th\u00f4ng tin <\/span><b>h\u00e0m th\u1eddi gian trong excel<\/b><span style=\"font-weight: 400;\">. Hy v\u1ecdng b\u00e0i vi\u1ebft cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c c\u1ea7n thi\u1ebft h\u1ed7 tr\u1ee3 trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh<\/span><b>.<\/b><span style=\"font-weight: 400;\"> M\u1ecdi th\u1eafc m\u1eafc c\u1ee7a c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c Teky gi\u1ea3i \u0111\u00e1p c\u1ee5 th\u1ec3 h\u01a1n \u1edf c\u00e1c b\u00e0i sau nh\u00e9.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Khi s\u1eed d\u1ee5ng excel, b\u1ea1n ch\u1eafc ch\u1eafn s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng t\u1edbi c\u00e1c h\u00e0m th\u1eddi gian \u0111\u1ec3 ho\u00e0n th\u00e0nh m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c \u0111\u1eb7c th\u00f9. \u0110\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi, c\u00f4ng vi\u1ec7c n\u00e0y kh\u00e1 kh\u00f3 kh\u0103n khi h\u1ecd ch\u01b0a c\u00f3 trong tay th\u00f4ng tin v\u1ec1 ch\u00fang. V\u1eady c\u1ee5 th\u1ec3 H\u00e0m th\u1eddi gian trong excel l\u00e0 &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12391,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12199","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng<\/title>\n<meta name=\"description\" content=\"H\u00e0m th\u1eddi gian trong excel l\u00e0 lo\u1ea1i h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong to\u00e1n h\u1ecdc. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m th\u1eddi gian trong excel l\u00e0 lo\u1ea1i h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong to\u00e1n h\u1ecdc. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-22T14:29:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T07:25:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng\",\"datePublished\":\"2022-11-22T14:29:58+00:00\",\"dateModified\":\"2022-12-08T07:25:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\"},\"wordCount\":1624,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\",\"name\":\"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg\",\"datePublished\":\"2022-11-22T14:29:58+00:00\",\"dateModified\":\"2022-12-08T07:25:15+00:00\",\"description\":\"H\u00e0m th\u1eddi gian trong excel l\u00e0 lo\u1ea1i h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong to\u00e1n h\u1ecdc. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg\",\"width\":600,\"height\":338,\"caption\":\"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng","description":"H\u00e0m th\u1eddi gian trong excel l\u00e0 lo\u1ea1i h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong to\u00e1n h\u1ecdc. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng","og_description":"H\u00e0m th\u1eddi gian trong excel l\u00e0 lo\u1ea1i h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong to\u00e1n h\u1ecdc. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-22T14:29:58+00:00","article_modified_time":"2022-12-08T07:25:15+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng","datePublished":"2022-11-22T14:29:58+00:00","dateModified":"2022-12-08T07:25:15+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/"},"wordCount":1624,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/","name":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg","datePublished":"2022-11-22T14:29:58+00:00","dateModified":"2022-12-08T07:25:15+00:00","description":"H\u00e0m th\u1eddi gian trong excel l\u00e0 lo\u1ea1i h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u trong to\u00e1n h\u1ecdc. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c t\u00ednh m\u00e0 ch\u00fang t\u00f4i mu\u1ed1n gi\u1edbi thi\u1ec7u.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/ham-time-trong-excel-2.jpg","width":600,"height":338,"caption":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-thoi-gian-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m th\u1eddi gian trong excel l\u00e0 g\u00ec? C\u00e1c h\u00e0m th\u1eddi gian th\u01b0\u1eddng \u1ee9ng d\u1ee5ng"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12199"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12199\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12391"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}