{"id":5066,"date":"2023-07-04T07:11:11","date_gmt":"2023-07-04T07:11:11","guid":{"rendered":"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/"},"modified":"2023-07-04T07:11:11","modified_gmt":"2023-07-04T07:11:11","slug":"unggul-rata-rata-usia","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/","title":{"rendered":"Cara menghitung rata-rata masa kerja karyawan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung rata-rata masa kerja karyawan di sebuah perusahaan di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut yang menunjukkan tanggal mulai dan berakhirnya berbagai karyawan di sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39487 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aten1.png\" alt=\"\" width=\"477\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung senioritas setiap karyawan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung senioritas karyawan pertama:<\/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 mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39488 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aten2.png\" alt=\"\" width=\"470\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom D sekarang menunjukkan senioritas (dalam tahun desimal) setiap karyawan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>YEARFRAC<\/strong> mengembalikan jumlah tahun desimal antara tanggal mulai dan tanggal akhir tertentu.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung durasi hunian rata-rata<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa mengetikkan rumus berikut di sel <strong>D11<\/strong> untuk menghitung rata-rata masa kerja karyawan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <b>=AVERAGE( <span style=\"color: #3366ff;\">D2:D11<\/span> )<\/b><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39489\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aten3.png\" alt=\"menghitung senioritas rata-rata di Excel\" width=\"448\" height=\"366\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata masa kerja karyawan pada perusahaan ini kurang lebih <strong>4,25 tahun<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menampilkan angka ini dalam tahun dan bulan, Anda bisa mengetikkan rumus berikut di sel <strong>E11<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=INT( <span style=\"color: #3366ff;\">D11<\/span> ) &amp; \" years, \" &amp; INT(( <span style=\"color: #3366ff;\">D11<\/span> -INT( <span style=\"color: #3366ff;\">D11<\/span> ))*12) &amp; \" months\"<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39490 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aten4.png\" alt=\"\" width=\"661\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata masa kerja karyawan di perusahaan ini kurang lebih <strong>4 tahun 3 bulan<\/strong> .<\/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> <span style=\"color: #000000;\"><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><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung rata-rata masa kerja karyawan di sebuah perusahaan di Excel. Untungnya, hal ini mudah dilakukan dan contoh langkah demi langkah berikut menunjukkan cara melakukannya. Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data berikut yang menunjukkan tanggal mulai dan berakhirnya berbagai karyawan di sebuah perusahaan: Langkah 2: Hitung senioritas setiap karyawan Selanjutnya, [&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 Rata-Rata Masa Kerja Karyawan di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata masa kerja karyawan di Excel, dengan contoh lengkap.\" \/>\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\/unggul-rata-rata-usia\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rata-Rata Masa Kerja Karyawan di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata masa kerja karyawan di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T07:11:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aten1.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\/unggul-rata-rata-usia\/\",\"url\":\"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/\",\"name\":\"Cara Menghitung Rata-Rata Masa Kerja Karyawan di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T07:11:11+00:00\",\"dateModified\":\"2023-07-04T07:11:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata masa kerja karyawan di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata masa kerja karyawan di excel\"}]},{\"@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 Rata-Rata Masa Kerja Karyawan di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung rata-rata masa kerja karyawan di Excel, dengan contoh lengkap.","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\/unggul-rata-rata-usia\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Masa Kerja Karyawan di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata masa kerja karyawan di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/","og_site_name":"Statorials","article_published_time":"2023-07-04T07:11:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/aten1.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\/unggul-rata-rata-usia\/","url":"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/","name":"Cara Menghitung Rata-Rata Masa Kerja Karyawan di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T07:11:11+00:00","dateModified":"2023-07-04T07:11:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata masa kerja karyawan di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/unggul-rata-rata-usia\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata masa kerja karyawan di excel"}]},{"@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\/5066"}],"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=5066"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5066\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}