{"id":3827,"date":"2023-07-15T07:53:55","date_gmt":"2023-07-15T07:53:55","guid":{"rendered":"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/"},"modified":"2023-07-15T07:53:55","modified_gmt":"2023-07-15T07:53:55","slug":"menghitung-durasi-hunian-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/","title":{"rendered":"Cara menghitung waktu hunian di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan salah satu rumus berikut untuk menghitung senioritas karyawan di Excel:<\/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: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> ,\"y\") &amp; \" years , \"&amp; DATEDIF( <span style=\"color: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> ,\"ym\") &amp; \" months\"<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Hitung masa kerja dalam tahun dalam bentuk desimal (misal 14,16944 tahun)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=YEARFRAC( <span style=\"color: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">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 memperlihatkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30994 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat1.jpg\" alt=\"\" width=\"478\" height=\"436\" 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: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> ,\"y\") &amp; \" years , \"&amp; DATEDIF( <span style=\"color: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> ,\"ym\") &amp; \" months\"<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><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><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30995\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat2.jpg\" alt=\"menghitung kepemilikan di Excel\" width=\"672\" height=\"468\" 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: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">C2<\/span> , \"d\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan menampilkan senioritas dalam hitungan hari, bukan tahun dan bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya masa kerja pegawai pertama adalah 5.173 hari.<\/span><\/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: #3366ff;\">B2<\/span> , <span style=\"color: #ff0000;\">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-30996 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat3.jpg\" alt=\"\" width=\"549\" height=\"501\" 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.169 tahun<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ben mempunyai masa jabatan <strong>3.894 tahun<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Charles mempunyai masa jabatan <strong>9.281 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 fungsi Excel <strong>YEARFRAC<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8\" 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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/perbedaan-antara-tanggal-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung selisih dua tanggal di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-bulan-antar-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah bulan antar tanggal di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-kondisional-excel-berdasarkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menerapkan pemformatan bersyarat berdasarkan tanggal di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan salah satu rumus berikut untuk menghitung senioritas karyawan di Excel: Rumus 1: Hitung tenor dalam tahun dan bulan (misal 14 tahun, 2 bulan) =DATEDIF( B2 , C2 ,&#8221;y&#8221;) &amp; &#8221; years , &#8220;&amp; DATEDIF( B2 , C2 ,&#8221;ym&#8221;) &amp; &#8221; months&#8221; Rumus 2: Hitung masa kerja dalam tahun dalam bentuk desimal (misal [&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 Excel (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung tenor 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\/menghitung-durasi-hunian-di-excel\/\" \/>\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 Excel (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung tenor di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T07:53:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat1.jpg\" \/>\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\/menghitung-durasi-hunian-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/\",\"name\":\"Cara Menghitung Senioritas di Excel (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T07:53:55+00:00\",\"dateModified\":\"2023-07-15T07:53:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung tenor di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung waktu hunian di excel (dengan contoh)\"}]},{\"@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 Excel (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menghitung tenor 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\/menghitung-durasi-hunian-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Senioritas di Excel (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung tenor di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-15T07:53:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mandat1.jpg"}],"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\/menghitung-durasi-hunian-di-excel\/","url":"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/","name":"Cara Menghitung Senioritas di Excel (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T07:53:55+00:00","dateModified":"2023-07-15T07:53:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung tenor di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menghitung-durasi-hunian-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung waktu hunian di excel (dengan contoh)"}]},{"@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\/3827"}],"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=3827"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3827\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}