{"id":1078,"date":"2022-04-19T21:40:48","date_gmt":"2022-04-19T14:40:48","guid":{"rendered":"https:\/\/dt-corp.com.vn\/?p=1078"},"modified":"2022-04-19T21:40:48","modified_gmt":"2022-04-19T14:40:48","slug":"cach-cong-va-tru-thoi-gian-trong-microsoft-excel","status":"publish","type":"post","link":"https:\/\/dt-corp.com.vn\/?p=1078","title":{"rendered":"C\u00e1ch c\u1ed9ng v\u00e0 tr\u1eeb th\u1eddi gian trong Microsoft Excel"},"content":{"rendered":"

\"\"<\/h3>\n

Trong Microsoft Excel c\u00f3 r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u00e0 c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch cho \u0111\u1eddi s\u1ed1ng c\u1ee7a b\u1ea1n. V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 xem \u0111\u01b0\u1ee3c c\u1ea3 th\u1eddi gian ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c nh\u1ecf. C\u1ed9ng v\u00e0 tr\u1eeb th\u1eddi gian tr\u00ean\u00a0Microsoft Excel<\/a>\u00a0gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 xem kho\u1ea3ng th\u1eddi gian b\u1ea1n \u0111\u00e3 d\u00e0nh cho c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh l\u00e0 bao l\u00e2u. \u0110\u1ecdc b\u00e0i vi\u1ebft \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n nh\u00e9.<\/strong><\/h3>\n

C\u1ed9ng th\u1eddi gian trong Microsoft Excel<\/h3>\n

C\u00e1ch n\u00e0y s\u1ebd k\u1ebft h\u1ee3p c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 t\u00ednh t\u1ed5ng th\u1eddi gian ch\u00ednh x\u00e1c trong Excel.<\/p>\n

\u0110\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 gi\u1edd v\u00e0 ph\u00fat<\/h4>\n

L\u01b0u \u00fd r\u1eb1ng ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u1ea5u tr\u00fac H:MM \u0111\u1ec3 lu\u00f4n \u0111\u1ed3ng b\u1ed9 v\u1edbi gi\u1edd v\u00e0 ph\u00fat hi\u1ec7n t\u1ea1i. M\u1eb7c d\u00f9 Excel s\u1ebd nh\u1eadn ra khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 lu\u00f4n \u0111\u1ea3m b\u1ea3o b\u1eb1ng c\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 c\u1ee7a m\u00ecnh.<\/p>\n

\n
\n
\n
Ch\u1ecdn c\u00e1c \u00f4 v\u00e0 nh\u1ea5n chu\u1ed9t ph\u1ea3i r\u1ed3i ch\u1ecdn \u201cFormat Cells\u201d ho\u1eb7c v\u00e0o Home, ch\u1ecdn \u201cFormat\u201d trong thanh c\u00f4ng c\u1ee5 v\u00e0 ch\u1ecdn \u201cFormat Cells\u201d.<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\"C\u00e1ch<\/p>\n

Trong c\u1eeda s\u1ed5 Format Cells, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111ang \u1edf tab Number. Sau \u0111\u00f3 ch\u1ecdn \u201cCustom\u201d trong Category. K\u1ebf ti\u1ebfp b\u1ea1n ch\u1ecdn \u201ch:mm\u201d t\u1eeb danh s\u00e1ch ho\u1eb7c nh\u1eadp \u0111\u1ecbnh d\u1ea1ng v\u00e0o \u00f4 Type.<\/p>\n

\"C\u00e1ch<\/p>\n

Nh\u1ea5n v\u00e0o \u201cOK\u201d \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4.<\/p>\n

C\u1ed9ng th\u1eddi gian b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/h4>\n

Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp th\u1eddi gian c\u1ee7a m\u00ecnh. Nh\u1eadp c\u00f4ng th\u1ee9c sau, thay th\u1ebf c\u00e1c tham chi\u1ebfu \u00f4 th\u00e0nh \u00f4 b\u1ea1n mu\u1ed1n.<\/p>\n

=F2+F3<\/code><\/p>\n

Nh\u1ea5n Enter \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y t\u1ed5ng s\u1ed1 gi\u1edd v\u00e0 ph\u00fat c\u1ee7a m\u00ecnh cho c\u00e1c \u00f4 \u0111\u00f3.<\/p>\n

\"th\u00eam<\/p>\n

C\u1ed9ng th\u1eddi gian b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sum<\/h4>\n

N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u \u00f4 d\u1eef li\u1ec7u, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUM, \u0111\u00f3 l\u00e0 s\u1ef1 l\u1ef1a ch\u1ecdn d\u1ec5 d\u00e0ng nh\u1ea5t cho b\u1ea1n.<\/p>\n

Ch\u1ecdn \u00f4 cu\u1ed1i c\u1ed9t d\u1eef li\u1ec7u. Chuy\u1ec3n \u0111\u1ebfn tab Home v\u00e0 ch\u1ecdn\u00a0 \u201cSum\u201d (tr\u01b0\u1edbc \u0111\u00e2y c\u00f3 t\u00ean l\u00e0 \u201cAutoSum\u201d).<\/p>\n

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

\"C\u00e1ch<\/p>\n

Excel s\u1ebd x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. N\u1ebfu kh\u00f4ng, ch\u1ec9 c\u1ea7n k\u00e9o qua c\u00e1c \u00f4 ch\u1ee9a th\u1eddi gian c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Enter.<\/p>\n

\"C\u00e1ch<\/p>\n

B\u1ea1n s\u1ebd th\u1ea5y t\u1ed5ng s\u1ed1 gi\u1edd v\u00e0 ph\u00fat c\u1ee7a c\u00e1c \u00f4 d\u1eef li\u1ec7u.<\/p>\n

\"C\u00e1ch<\/p>\n

\u0110\u1ecbnh d\u1ea1ng th\u1eddi gian theo 24 gi\u1edd<\/h4>\n

Khi b\u1ea1n th\u00eam c\u00e1c \u00f4 s\u1eed d\u1ee5ng th\u1eddi gian 24 gi\u1edd, r\u1ea5t c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c. \u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3.<\/p>\n

Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn \u201cFormat Cells\u201d, ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Home > Format > Format Cells.<\/p>\n

Trong c\u1eeda s\u1ed5 Format Cells,\u00a0 ch\u1ecdn tab Number, sau \u0111\u00f3 nh\u1ea5n \u201cCustom\u201d \u1edf Category v\u00e0 ch\u1ecdn \u00a0\u201c[h]:mm;@\u201d.<\/p>\n

\"C\u00e1ch<\/p>\n

Nh\u1ea5p v\u00e0o \u201cOK\u201d \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng cho \u00f4. Sau \u0111\u00f3, b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c cho c\u00e1c \u00f4 s\u1eed d\u1ee5ng 24 gi\u1edd.<\/p>\n

<\/ins><\/ins><\/ins><\/p>\n
\n
\n
\"C\u00e1ch<\/div>\n<\/div>\n<\/div>\n<\/div>\n

Tr\u1eeb th\u1eddi gian trong Microsoft Excel<\/h3>\n

B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tr\u1eeb th\u1eddi gian k\u1ebft th\u00fac v\u1edbi th\u1eddi gian b\u1eaft \u0111\u1ea7u d\u1ef1 \u00e1n trong Excel.<\/p>\n

\u0110\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 th\u1eddi gian<\/h4>\n

Gi\u1ed1ng nh\u01b0 khi c\u1ed9ng gi\u1edd v\u00e0 ph\u00fat, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c \u00f4 th\u1eddi gian c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng ch\u00ednh x\u00e1c. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n s\u1ebd \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian th\u00e0nh 4:30 am.<\/p>\n

Ch\u1ecdn c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn \u201cFormat Cells\u201d, ho\u1eb7c c\u00f3 th\u1ec3 ch\u1ecdn Home > Format > Format Cells.<\/p>\n

Trong c\u1eeda s\u1ed5 Format Cells, tr\u00ean tab Number, ch\u1ecdn \u201cTime\u201d \u1edf Category. Ch\u1ecdn \u201c1:30 PM\u201d cho \u0111\u1ecbnh d\u1ea1ng gi\u1edd v\u00e0 ph\u00fat.<\/p>\n

\"C\u00e1ch<\/p>\n

Nh\u1ea5p v\u00e0o \u201cOK\u201d \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4 c\u1ee7a b\u1ea1n.<\/p>\n

Tr\u1eeb th\u1eddi gian<\/h4>\n

Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c sau, thay th\u1ebf c\u00e1c tham chi\u1ebfu \u00f4 b\u1eb1ng tham chi\u1ebfu c\u1ee7a ri\u00eang b\u1ea1n.<\/p>\n

=C2-B2<\/code><\/p>\n

Nh\u1ea5n Enter \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c.<\/p>\n

Ti\u1ebfp theo, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng \u00f4 theo gi\u1edd v\u00e0 ph\u00fat \u0111\u1ec3 hi\u1ec3n th\u1ecb t\u1ed5ng th\u1eddi gian \u0111\u00e3 s\u1eed d\u1ee5ng. Theo m\u1eb7c \u0111\u1ecbnh, k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb theo th\u1eddi gian trong ng\u00e0y.<\/p>\n

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

\"Tr\u1eeb<\/p>\n

Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn \u00a0\u201cFormat Cells\u201d ho\u1eb7c c\u00f3 th\u1ec3 ch\u1ecdn Home > Format > Format Cells.<\/p>\n

Trong c\u1eeda s\u1ed5 Format Cells, \u1edf tab Number, ch\u1ecdn \u201cCustom\u201d \u1edf category. Ch\u1ecdn \u201ch:mm\u201d ho\u1eb7c nh\u1eadp \u0111\u1ecbnh d\u1ea1ng n\u00e0y v\u00e0o Type v\u00e0 ch\u1ecdn \u201cOK\u201d.<\/p>\n

\"C\u00e1ch<\/p>\n

Sau \u0111\u00f3, b\u1ea1n s\u1ebd th\u1ea5y s\u1ed1 gi\u1edd v\u00e0 ph\u00fat m\u00e0 b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng.\"C\u00e1ch<\/p>\n

Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tham kh\u1ea3o kh\u00f3a h\u1ecdc Excel mi\u1ec5n ph\u00ed\u00a0t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n

Ngu\u1ed3n: anonyviet.com<\/p>\n","protected":false},"excerpt":{"rendered":"

Trong Microsoft Excel c\u00f3 r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u00e0 c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch cho \u0111\u1eddi s\u1ed1ng c\u1ee7a b\u1ea1n. V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 xem \u0111\u01b0\u1ee3c c\u1ea3 th\u1eddi gian ch\u1ec9 v\u1edbi","protected":false},"author":1,"featured_media":1079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-1078","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/dt-corp.com.vn\/wp-content\/uploads\/2022\/04\/cach-lay-lai-file-excel-2007-chua-luu-cho-nguoi-dung-2.jpg","_links":{"self":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts\/1078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1078"}],"version-history":[{"count":1,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts\/1078\/revisions"}],"predecessor-version":[{"id":1080,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/posts\/1078\/revisions\/1080"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=\/wp\/v2\/media\/1079"}],"wp:attachment":[{"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dt-corp.com.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}