{"id":4658,"date":"2023-07-09T05:27:32","date_gmt":"2023-07-09T05:27:32","guid":{"rendered":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/"},"modified":"2023-07-09T05:27:32","modified_gmt":"2023-07-09T05:27:32","slug":"hitung-durasi-hunian-di-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/","title":{"rendered":"Cara menghitung senioritas di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan salah satu rumus berikut untuk menghitung masa kerja karyawan di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: Hitung tenor dalam tahun dan bulan (misal 14 tahun, 2 bulan)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=DATEDIF( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> ,\" <span style=\"color: #008000;\">y<\/span> \") &amp; \" <span style=\"color: #008000;\">years,<\/span> \"&amp; DATEDIF( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> ,\" <span style=\"color: #008000;\">ym<\/span> \") &amp; \" <span style=\"color: #008000;\">months<\/span> \"<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Hitung masa kerja dalam tahun dalam bentuk desimal (misal 14,1694 tahun)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=YEARFRAC( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kedua rumus tersebut mengasumsikan tanggal mulai ada di sel <strong>B2<\/strong> dan tanggal akhir ada di sel <strong>C2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36351 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat1.png\" alt=\"\" width=\"493\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung tenor dalam tahun dan bulan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung senioritas karyawan pertama dalam tahun dan bulan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=DATEDIF( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> ,\" <span style=\"color: #008000;\">y<\/span> \") &amp; \" <span style=\"color: #008000;\">years,<\/span> \"&amp; DATEDIF( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> ,\" <span style=\"color: #008000;\">ym<\/span> \") &amp; \" <span style=\"color: #008000;\">months<\/span> \"<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom D untuk menghitung senioritas setiap karyawan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36352\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat2.png\" alt=\"menghitung kepemilikan di Google Sheets\" width=\"642\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai pada kolom D menampilkan masa kerja masing-masing karyawan dalam hitungan tahun dan bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda hanya ingin menampilkan waktu hunian dalam total hari, Anda dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=DATEDIF( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> , \u201c <span style=\"color: #008000;\">d<\/span> \u201d)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menampilkan senioritas dalam hari, bukan tahun dan bulan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36353 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat3.png\" alt=\"\" width=\"543\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung masa kerja dalam tahun dalam bentuk desimal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung senioritas karyawan pertama dalam satuan tahun dalam bentuk desimal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=YEARFRAC( <span style=\"color: #ff6600;\">B2<\/span> , <span style=\"color: #800080;\">C2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom D untuk menghitung senioritas setiap karyawan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36354 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat4.png\" alt=\"\" width=\"507\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai pada kolom D menampilkan senioritas setiap karyawan dalam satuan tahun dalam bentuk desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Andy mempunyai masa jabatan <strong>14,1694 tahun<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bob mempunyai masa jabatan <strong>3,8944 tahun<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Chad mempunyai mandat <strong>9,2805 tahun<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fitur Google Sheets <strong>YEARFRAC<\/strong> <a href=\"https:\/\/support.google.com\/docs\/answer\/3092989?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tanggal-gabungan-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menggabungkan tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-jika-berfungsi-dengan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan fungsi IF dengan tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-jika-antara-dua-tanggal\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: hitung rata-rata antara dua tanggal<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan salah satu rumus berikut untuk menghitung masa kerja karyawan di Google Spreadsheet: Rumus 1: Hitung tenor dalam tahun dan bulan (misal 14 tahun, 2 bulan) =DATEDIF( B2 , C2 ,&#8221; y &#8220;) &amp; &#8221; years, &#8220;&amp; DATEDIF( B2 , C2 ,&#8221; ym &#8220;) &amp; &#8221; months &#8221; Rumus 2: Hitung masa kerja [&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>Cara menghitung senioritas di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung senioritas di Google Sheets, beserta contohnya.\" \/>\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\/hitung-durasi-hunian-di-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung senioritas di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung senioritas di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T05:27:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/\",\"name\":\"Cara menghitung senioritas di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T05:27:32+00:00\",\"dateModified\":\"2023-07-09T05:27:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung senioritas di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung senioritas di google sheets\"}]},{\"@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":"Cara menghitung senioritas di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung senioritas di Google Sheets, beserta contohnya.","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\/hitung-durasi-hunian-di-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung senioritas di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung senioritas di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-09T05:27:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/","url":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/","name":"Cara menghitung senioritas di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T05:27:32+00:00","dateModified":"2023-07-09T05:27:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung senioritas di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hitung-durasi-hunian-di-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung senioritas di google sheets"}]},{"@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\/4658"}],"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=4658"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4658\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}