{"id":9787,"date":"2025-01-03T01:47:17","date_gmt":"2025-01-03T01:47:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/huong-dan-tinh-gio-trong-excel-don-gian\/"},"modified":"2025-01-03T01:47:17","modified_gmt":"2025-01-03T01:47:17","slug":"huong-dan-tinh-gio-trong-excel-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/huong-dan-tinh-gio-trong-excel-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00ednh gi\u1edd trong Excel \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch t\u00ednh gi\u1edd trong Excel \u0111\u01a1n gi\u1ea3n, gi\u00fap c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n v\u1edbi th\u1eddi gian m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.<\/p>\n

T\u00ednh gi\u1edd trong Excel<\/h3>\n

L\u1ea7n n\u00e0y, b\u1ea1n h\u00e3y t\u1ef1 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh nh\u00e9. Kh\u00f4ng ph\u1ea3i l\u01b0\u1eddi \u0111\u00e2u, m\u00e0 \u0111i\u1ec1u \u0111\u00f3 gi\u00fap cho thao t\u00e1c c\u1ee7a b\u1ea1n th\u00f4i. Ch\u00fang ta s\u1ebd \u0111i theo 2 b\u01b0\u1edbc c\u01a1 b\u1ea3n sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel c\u1ee7a b\u1ea1n l\u00ean. Ghi v\u00e0o \u00f4 A1 \u201cGi\u1edd v\u00e0o\u201d v\u00e0 \u00f4 B1 \u201cGi\u1edd ra\u201d. G\u00f5 th\u1eddi gian b\u1eaft \u0111\u1ea7u b\u1ea5t k\u00ec \u1edf \u00f4 A2 v\u00e0 k\u1ebft th\u00fac \u1edf \u00f4 B2, v\u1edbi \u0111i\u1ec1u ki\u1ec7n gi\u1edd b\u1eaft \u0111\u1ea7u nh\u1ecf h\u01a1n gi\u1edd k\u1ebft th\u00fac.<\/p>\n

G\u00f5 v\u00e0o \u00f4 C1 \u201cK\u1ebft qu\u1ea3\u201d v\u00e0 click chu\u1ed9t v\u00e0o \u00f4 C2.<\/p>\n

B\u01b0\u1edbc 2:\u00a0<\/strong>Nh\u1eadp c\u00f4ng th\u1ee9c \u201c=B2-A2\u201d v\u00e0 \u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Thay \u0111\u1ed5i format b\u1eb1ng c\u00e1ch click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn\u00a0Format Cells\u2026<\/strong> Sau \u0111\u00f3 t\u1ea1i th\u1ebb Number<\/strong>\u00a0ch\u1ecdn\u00a0Custom<\/strong>.<\/p>\n

G\u00f5 v\u00e0o tr\u01b0\u1eddng \u201cType\u201d ch\u1eef \u201ch\u201d.<\/p>\n

K\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 \u0111\u1ecbnh d\u1ea1ng gi\u1edd.<\/p>\n

Ho\u1eb7c:<\/em><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u0110\u1ec3 l\u00e0m tr\u1ef1c ti\u1ebfp c\u00e1c b\u01b0\u1edbc tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 C2 nh\u01b0 sau:<\/p>\n

=TEXT(B2-A2,\u201dh\u201d)<\/em><\/p>\n

K\u1ebft qu\u1ea3 c\u0169ng tr\u1ea3 v\u1ec1 gi\u1edd.<\/p>\n

k\u1ebft qu\u1ea3<\/figcaption><\/figure>\n

Kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o? B\u00e2y gi\u1edd h\u00e3y l\u00e0m t\u01b0\u01a1ng t\u1ef1 cho nh\u1eefng tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nh\u00e9!<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t<\/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":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9788,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9787","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9787","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=9787"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9787\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9788"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}