{"id":11487,"date":"2025-01-15T03:34:21","date_gmt":"2025-01-15T03:34:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-nhanh-chong-cong-them-gio-phut-giay-vao-thoi-gian-trong-excel\/"},"modified":"2025-01-15T03:34:21","modified_gmt":"2025-01-15T03:34:21","slug":"cach-nhanh-chong-cong-them-gio-phut-giay-vao-thoi-gian-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-nhanh-chong-cong-them-gio-phut-giay-vao-thoi-gian-trong-excel\/","title":{"rendered":"C\u00e1ch nhanh ch\u00f3ng c\u1ed9ng th\u00eam gi\u1edd\/ph\u00fat\/gi\u00e2y v\u00e0o th\u1eddi gian trong Excel"},"content":{"rendered":"
\n

Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c \u00f4 ch\u1ec9 th\u1eddi gian trong m\u1ed9t b\u1ea3ng t\u00ednh, b\u00e2y gi\u1edd b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam gi\u1edd, ph\u00fat, gi\u00e2y v\u00e0o c\u00e1c \u00f4 t\u00ednh c\u00f3 \u0111\u1ed3ng th\u1eddi ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1, nh\u01b0ng t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t m\u1eb9o nhanh h\u01a1n.<\/p>\n

Trong Excel, nh\u00ecn chung, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c c\u1ed9ng gi\u1edd, ph\u00fat, ho\u1eb7c gi\u00e2y v\u00e0o \u00f4 \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian.<\/p>\n

1. T\u1ea1i \u00f4 tr\u1ea3 k\u1ebft qu\u1ea3 t\u00ednh, nh\u1eadp c\u00f4ng th\u1ee9c =A2+1\/24<\/strong>, nh\u1ea5n Enter v\u00e0 d\u00f9ng chu\u1ed9t k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c. Nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y<\/p>\n

\"doc<\/p>\n

2. Nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Cells<\/strong><\/em>. Trong h\u1ed9p tho\u1ea1i Format Cells<\/strong><\/em>, t\u1ea1i tab Number<\/strong><\/em>, ch\u1ecdn Custom<\/strong><\/em> t\u1eeb danh m\u1ee5c Category<\/strong><\/em>, nh\u1eadp m\/d\/yyy hh:mm:ss trong h\u1ed9p Type<\/strong><\/em>. Nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\"doc<\/p>\n

\"doc<\/p>\n

3. Nh\u1ea5p OK. V\u1eady l\u00e0 t\u1ea1i c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed9ng th\u00eam 1 gi\u1edd,<\/p>\n

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

\"doc<\/p>\n

Ch\u00fa \u00fd:<\/strong><\/p>\n

1. N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam m\u1ed9t ph\u00fat v\u00e0o \u00f4 t\u00ednh, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =A2+1\/1440<\/strong>, n\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed9ng th\u00eam m\u1ed9t gi\u00e2y v\u00e0o \u00f4 t\u00ednh, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c: =A2+1\/72000<\/strong>.<\/p>\n

2. Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, \u201c1\u201d l\u00e0 s\u1ed1 c\u1ed9ng th\u00eam m\u1ed9t gi\u1edd, m\u1ed9t ph\u00fat ho\u1eb7c m\u1ed9t gi\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i theo \u00fd b\u1ea1n mu\u1ed1n.<\/p>\n

3. N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam \u0111\u1ed3ng th\u1eddi gi\u1edd, ph\u00fat, gi\u00e2y v\u00e0o m\u1ed9t ng\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =A2+TIME(23,23,34)<\/strong>, c\u00f3 ngh\u0129a l\u00e0 th\u00eam v\u00e0o 23 gi\u1edd, 23 ph\u00fat, 34 gi\u00e2y v\u00e0o \u00f4 ng\u00e0y th\u00e1ng. Tuy nhi\u00ean, v\u1edbi c\u00f4ng th\u1ee9c n\u00e0y, b\u1ea1n kh\u00f4ng th\u1ec3 th\u00eam th\u1eddi gian v\u01b0\u1ee3t qu\u00e1 24 gi\u1edd.<\/p>\n

Nh\u1eefng m\u1eb9o nh\u1ecf n\u00e0y tuy \u00edt s\u1eed d\u1ee5ng nh\u01b0ng s\u1ebd l\u00e0 v\u0169 kh\u00ed m\u1ea1nh c\u1ee7a b\u1ea1n trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ea7n thi\u1ebft. Excel c\u00f3 r\u1ea5t nhi\u1ec1u th\u1ee7 thu\u1eadt nh\u1ecf nh\u01b0 v\u1eady m\u00e0 c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft. 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":"

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