{"id":12458,"date":"2025-01-15T08:51:11","date_gmt":"2025-01-15T08:51:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-nhap-du-lieu-va-tru-thoi-gian-de-tinh-luong-dung-trong-excel\/"},"modified":"2025-01-15T08:51:11","modified_gmt":"2025-01-15T08:51:11","slug":"cach-nhap-du-lieu-va-tru-thoi-gian-de-tinh-luong-dung-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-nhap-du-lieu-va-tru-thoi-gian-de-tinh-luong-dung-trong-excel\/","title":{"rendered":"C\u00e1ch nh\u1eadp d\u1eef li\u1ec7u v\u00e0 tr\u1eeb th\u1eddi gian \u0111\u1ec3 t\u00ednh l\u01b0\u01a1ng \u0111\u00fang trong Excel"},"content":{"rendered":"
\n

Nhi\u1ec1u b\u1ea1n s\u1ebd g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 tr\u1eeb th\u1eddi gian trong Excel. V\u1ea5n \u0111\u1ec1 l\u00e0 \u1edf ch\u1ed7 th\u1eddi gian nh\u1eadp v\u00e0o b\u1ecb thi\u1ebfu d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m n\u00ean t\u00ednh to\u00e1n b\u1ecb sai. \u0110\u1ec3 t\u00ednh to\u00e1n v\u00e0 tr\u1eeb th\u1eddi gian ch\u00ednh x\u00e1c, b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadp d\u1eef li\u1ec7u th\u1eddi gian nh\u01b0 sau trong Excel. Tr\u01b0\u1edbc khi nh\u1eadp th\u1eddi gian, ng\u00e0y th\u00e1ng, b\u1ea1n n\u00ean \u0111\u1ecdc qua b\u00e0i vi\u1ebft l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u1ec9nh l\u1ea1i c\u00e1ch nh\u1eadp li\u1ec7u ng\u00e0y tr\u01b0\u1edbc th\u00e1ng sau trong Excel<\/a>.<\/p>\n

V\u00ed d\u1ee5: T\u00ednh th\u1eddi gian l\u00e0m vi\u1ec7c c\u1ee7a lao \u0111\u1ed9ng l\u00e0m vi\u1ec7c t\u1eeb 23 gi\u1edd h\u00f4m tr\u01b0\u1edbc \u0111\u1ebfn 4 gi\u1edd s\u00e1ng h\u00f4m sau. Gi\u1ea3 s\u1eed ch\u00fang ta l\u01b0u th\u1eddi gian b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c v\u00e0o \u00f4 A1, th\u1eddi gian k\u1ebft th\u00fac ca l\u00e0m v\u00e0o \u00f4 B1 v\u00e0 t\u00ednh th\u1eddi gian l\u00e0m vi\u1ec7c \u1edf \u00f4 C3, th\u00ec ch\u00fang ta c\u1ea7n \u0111i\u1ec1n l\u1ea7n l\u01b0\u1ee3t c\u00e1c \u00f4 n\u00e0y v\u1edbi n\u1ed9i dung nh\u01b0 sau:<\/p>\n

A1 = 14\/02\/2017 23:00:00<\/p>\n

B1 = 15\/02\/2017 04:00:00<\/p>\n

C1 = (B1-A1)*24<\/p>\n

ho\u1eb7c<\/p>\n

C1 = DAY(B1-A1)*24 + HOUR(B1-A1)<\/p>\n

Nh\u01b0 v\u1eady b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 \u0111\u00fang l\u00e0 5 gi\u1edd \u0111\u1ed3ng h\u1ed3.<\/p>\n

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

https:\/\/www.hocexcel.online\/ex101<\/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":"

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