{"id":4793,"date":"2023-07-07T21:20:49","date_gmt":"2023-07-07T21:20:49","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/"},"modified":"2023-07-07T21:20:49","modified_gmt":"2023-07-07T21:20:49","slug":"excel-mengonversi-kaki-dan-inci-ke-desimal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/","title":{"rendered":"Excel: cara mengubah kaki dan inci ke desimal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mengonversi kaki dan inci ke desimal di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTBEFORE( <span style=\"color: #3366ff;\">A2<\/span> ,\"'\")+TEXTBEFORE(TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> ,\"'\"),\"\"\"\")\/12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengubah kaki dan inci di sel <strong>A2<\/strong> menjadi angka desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika sel <strong>A2<\/strong> berisi <strong>6&#8217;5\u2033<\/strong> , rumus ini akan mengonversinya menjadi <strong>6.4167<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Konversi Kaki dan Inci ke Desimal di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan tinggi badan berbagai atlet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37412 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pouce1.png\" alt=\"\" width=\"484\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengonversi setiap tinggi badan dari kaki dan inci ke nilai desimal, kita dapat mengetikkan rumus berikut di sel <strong>B2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTBEFORE( <span style=\"color: #3366ff;\">A2<\/span> ,\"'\")+TEXTBEFORE(TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> ,\"'\"),\"\"\"\")\/12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37411\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pouce2.png\" alt=\"Excel mengonversi kaki dan inci menjadi desimal\" width=\"661\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan kaki dan inci di kolom A dalam bentuk desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">6 kaki dan 2 inci sama dengan <strong>6.1667<\/strong> kaki.<\/span><\/li>\n<li> <span style=\"color: #000000;\">6 kaki dan 5 inci sama dengan <strong>6.4167<\/strong> kaki.<\/span><\/li>\n<li> <span style=\"color: #000000;\">5 kaki dan 10 inci sama dengan <strong>5,8333<\/strong> kaki.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bagaimana cara kerja rumus ini?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ingat rumus yang kami gunakan untuk mengubah kaki dan inci ke desimal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=TEXTBEFORE( <span style=\"color: #3366ff;\">A2<\/span> ,\"'\")+TEXTBEFORE(TEXTAFTER( <span style=\"color: #3366ff;\">A2<\/span> ,\"'\"),\"\"\"\")\/12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Begini cara kerja rumus ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita menggunakan <strong>TEXTBEFORE(A2, \u201c&#8217;\u201d)<\/strong> untuk mengekstrak teks sebelum tanda kutip tunggal pertama di sel A2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini mengekstrak nilai <strong>6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian kita gunakan <strong>TEXTBEFORE(TEXTAFTER(A2,\u201d&#8217;\u201d),\u201d\u201d\u201d\u201d)\/12<\/strong> untuk mengekstrak teks antara tanda kutip tunggal dan tanda kutip ganda dan membaginya dengan 12.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan 2\/12 = <strong>0,1667<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kami menggunakan tanda plus ( <strong>+<\/strong> ) untuk menjumlahkan kedua nilai ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan 6 + 0.1667 = <strong>6.1667<\/strong> .<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-mengubah-waktu-menjadi-menit\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengubah durasi menjadi menit<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/\" target=\"_blank\" rel=\"noopener\">Excel: cara mengubah persentase menjadi rasio<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/stempel-waktu-excel-terkini\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengonversi stempel waktu UNIX menjadi tanggal<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mengonversi kaki dan inci ke desimal di Excel: =TEXTBEFORE( A2 ,&#8221;&#8216;&#8221;)+TEXTBEFORE(TEXTAFTER( A2 ,&#8221;&#8216;&#8221;),&#8221;&#8221;&#8221;&#8221;)\/12 Ini akan mengubah kaki dan inci di sel A2 menjadi angka desimal. Misalnya, jika sel A2 berisi 6&#8217;5\u2033 , rumus ini akan mengonversinya menjadi 6.4167 . Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: Cara mengonversi kaki dan inci ke desimal - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengonversi kaki dan inci ke nilai desimal di Excel, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengonversi kaki dan inci ke desimal - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengonversi kaki dan inci ke nilai desimal di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T21:20:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pouce1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/\",\"name\":\"Excel: Cara mengonversi kaki dan inci ke desimal - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T21:20:49+00:00\",\"dateModified\":\"2023-07-07T21:20:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengonversi kaki dan inci ke nilai desimal di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengubah kaki dan inci ke desimal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: Cara mengonversi kaki dan inci ke desimal - Statorial","description":"Tutorial ini menjelaskan cara mengonversi kaki dan inci ke nilai desimal di Excel, dengan sebuah contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengonversi kaki dan inci ke desimal - Statorial","og_description":"Tutorial ini menjelaskan cara mengonversi kaki dan inci ke nilai desimal di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/","og_site_name":"Statorials","article_published_time":"2023-07-07T21:20:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pouce1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/","url":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/","name":"Excel: Cara mengonversi kaki dan inci ke desimal - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T21:20:49+00:00","dateModified":"2023-07-07T21:20:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengonversi kaki dan inci ke nilai desimal di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengonversi-kaki-dan-inci-ke-desimal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengubah kaki dan inci ke desimal"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4793"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4793"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4793\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}