{"id":1365,"date":"2024-12-02T04:46:59","date_gmt":"2024-12-02T04:46:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/chuyen-doi-do-phut-giay-goc-sang-gia-tri-dung-de-tinh-toan-trong-excel\/"},"modified":"2024-12-02T04:46:59","modified_gmt":"2024-12-02T04:46:59","slug":"chuyen-doi-do-phut-giay-goc-sang-gia-tri-dung-de-tinh-toan-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/chuyen-doi-do-phut-giay-goc-sang-gia-tri-dung-de-tinh-toan-trong-excel\/","title":{"rendered":"Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ed9 ph\u00fat gi\u00e2y (g\u00f3c) sang gi\u00e1 tr\u1ecb d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n trong Excel"},"content":{"rendered":"
\n

Chuy\u1ec3n t\u1eeb 10.46 sang \u0111\u1ed9 ph\u00fat gi\u00e2y:<\/p>\n

A1 = 10.46<\/p>\n

S\u1eed d\u1ee5ng h\u00e0m Convert_Degree trong VBA nh\u01b0 sau:
\n=Convert_Degree(A1)
\nK\u1ebft qu\u1ea3 l\u00e0:\u00a010\u00b027\u201936\u201d<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

Chuy\u1ec3n ng\u01b0\u1ee3c l\u1ea1i:<\/p>\n

S\u1eed d\u1ee5ng function vi\u1ebft b\u1edfi VBA nh\u01b0 sau:<\/p>\n

=Convert_Decimal(\u201c10\u00b0 27\u2032 36\u2033\u201d\u201d)<\/p>\n

K\u1ebft qu\u1ea3:\u00a010.46<\/p>\n

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