{"id":4879,"date":"2023-07-06T22:22:47","date_gmt":"2023-07-06T22:22:47","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/"},"modified":"2023-07-06T22:22:47","modified_gmt":"2023-07-06T22:22:47","slug":"excel-menghitung-lama-menginap","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/","title":{"rendered":"Cara menghitung lama tinggal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung lama tinggal di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #3366ff;\">C2<\/span> = <span style=\"color: #ff0000;\">B2<\/span> , 1, <span style=\"color: #3366ff;\">C2<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah hari antara tanggal mulai di sel <strong>B2<\/strong> dan tanggal akhir di sel <strong>C2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika tanggal mulai dan tanggal akhir jatuh pada hari yang sama, maka rumus akan mengembalikan nilai <strong>1<\/strong> untuk menunjukkan bahwa lama menginap adalah 1 hari.<\/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: Cara menghitung lama tinggal di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang menunjukkan tanggal masuk dan tanggal keluar dari berbagai pasien di rumah sakit:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38101 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/je-reste1.png\" alt=\"\" width=\"476\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung lama rawat inap pasien pertama, kita dapat mengetikkan rumus berikut pada sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF( <span style=\"color: #3366ff;\">C2<\/span> = <span style=\"color: #ff0000;\">B2<\/span> , 1, <span style=\"color: #3366ff;\">C2<\/span> - <span style=\"color: #ff0000;\">B2<\/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-38102 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/je-reste2.png\" alt=\"\" width=\"542\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom D sekarang menunjukkan lama rawat inap setiap pasien.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Andy tinggal <strong>3<\/strong> hari.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bob tinggal <strong>4<\/strong> hari.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Chad tinggal <strong>1<\/strong> hari.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Harap diperhatikan bahwa pasien yang diterima dan dipulangkan pada hari yang sama memiliki masa rawat inap selama <strong>1<\/strong> hari.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita kemudian dapat mengetikkan rumus berikut ke dalam sel <strong>D14<\/strong> dan <strong>D15<\/strong> , masing-masing, untuk menghitung total lama rawat inap untuk semua pasien dan rata-rata lama rawat inap per pasien:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>H14<\/strong> : =Jumlah(H2:D13)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>D15<\/strong> : =RATA-RATA(D2:D13)<\/span><\/li>\n<\/ul>\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-38103\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/je-reste3.png\" alt=\"Excel menghitung lama tinggal\" width=\"628\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total lama rawat inap untuk semua pasien adalah <strong>152<\/strong> hari.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rata-rata lama rawat inap per pasien adalah <strong>12,67<\/strong> hari.<\/span><\/li>\n<\/ul>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/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\/tanggal-verifikasi-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara memeriksa apakah sel berisi tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mendapatkan-tanggal-dari-nomor-minggu\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mendapatkan tanggal dari nomor minggu<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanggal-konversi-excel-ke-yyyymmdd\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengonversi tanggal ke format YYYYMMDD<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghitung lama tinggal di Excel: =IF( C2 = B2 , 1, C2 &#8211; B2 ) Rumus khusus ini menghitung jumlah hari antara tanggal mulai di sel B2 dan tanggal akhir di sel C2 . Catatan : Jika tanggal mulai dan tanggal akhir jatuh pada hari yang sama, maka rumus [&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 Lama Tinggal di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung lama tinggal 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\/excel-menghitung-lama-menginap\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Lama Tinggal di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung lama tinggal di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T22:22:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/je-reste1.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-menghitung-lama-menginap\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/\",\"name\":\"Cara Menghitung Lama Tinggal di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T22:22:47+00:00\",\"dateModified\":\"2023-07-06T22:22:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung lama tinggal di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung lama tinggal 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 Lama Tinggal di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung lama tinggal 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\/excel-menghitung-lama-menginap\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Lama Tinggal di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung lama tinggal di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/","og_site_name":"Statorials","article_published_time":"2023-07-06T22:22:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/je-reste1.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-menghitung-lama-menginap\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/","name":"Cara Menghitung Lama Tinggal di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T22:22:47+00:00","dateModified":"2023-07-06T22:22:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung lama tinggal di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-lama-menginap\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung lama tinggal 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\/4879"}],"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=4879"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4879\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}