{"id":8100,"date":"2024-12-21T21:19:44","date_gmt":"2024-12-21T21:19:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cong-tong-thoi-gian-qua-24-gio-trong-excel\/"},"modified":"2024-12-21T21:19:44","modified_gmt":"2024-12-21T21:19:44","slug":"cong-tong-thoi-gian-qua-24-gio-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cong-tong-thoi-gian-qua-24-gio-trong-excel\/","title":{"rendered":"C\u1ed9ng t\u1ed5ng th\u1eddi gian qu\u00e1 24 gi\u1edd trong Excel"},"content":{"rendered":"
\n

\u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean, t\u00ednh t\u1ed5ng s\u1ed1 gi\u1edd cho thu\u00ea xe hay t\u00ednh t\u1ed5ng gi\u1edd l\u00e0m c\u1ee7a b\u1ea5t k\u00ec vi\u1ec7c g\u00ec ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1<\/strong>: t\u1ea1i \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng, \u0111\u1eb7t c\u00f4ng th\u1ee9c SUM(E2:E15)<\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn \u00f4 E17, b\u1ea5m CTRL + 1 \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/p>\n

B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn Category Custom\u00a0<\/strong>r\u1ed3i trong ph\u1ea7n Type\u00a0<\/strong>b\u00f5: [HH]:MM<\/strong> ho\u1eb7c [HH]:MM:SS<\/strong><\/p>\n

\"tinh\"tinh<\/a><\/p>\n

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\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u0110\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 gi\u1edd l\u00e0m c\u1ee7a nh\u00e2n vi\u00ean, t\u00ednh t\u1ed5ng s\u1ed1 gi\u1edd cho thu\u00ea..<\/p>\n","protected":false},"author":1,"featured_media":8101,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8100","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\/8100","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=8100"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8100\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8101"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}