{"id":4393,"date":"2023-07-11T11:15:34","date_gmt":"2023-07-11T11:15:34","guid":{"rendered":"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/"},"modified":"2023-07-11T11:15:34","modified_gmt":"2023-07-11T11:15:34","slug":"perbedaan-waktu-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/","title":{"rendered":"Cara menghitung selisih waktu di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut di VBA untuk menghitung selisih antara dua waktu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindTimeDifference()\n    \n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 7\n        <span style=\"color: #008000;\">'calculate time difference in days<\/span>\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)\n        \n        <span style=\"color: #008000;\">'calculate time difference in hours<\/span>\n        Range(\" <span style=\"color: #ff0000;\">D<\/span> \" &amp; i) = (Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) * 24\n        \n        <span style=\"color: #008000;\">'calculate time difference in minutes<\/span>\n        Range(\" <span style=\"color: #ff0000;\">E<\/span> \" &amp; i) = (Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) * 24 * 60\n        \n        <span style=\"color: #008000;\">'calculate time difference in seconds<\/span>\n        Range(\" <span style=\"color: #ff0000;\">F<\/span> \" &amp; i) = (Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) * 24 * 60 * 60\n    <span style=\"color: #0000ff;\">Next<\/span> i\n    \n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menghitung perbedaan antara waktu terkait dalam rentang <strong>A2:A7<\/strong> dan <strong>B2:B7<\/strong> dan mengembalikan hasil berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>C2:C7<\/strong> akan berisi perbedaan waktu dalam beberapa hari<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>D2:D7<\/strong> akan berisi perbedaan waktu dalam jam<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>E2:E7<\/strong> akan berisi perbedaan waktu dalam hitungan menit<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>F2:F7<\/strong> akan berisi perbedaan waktu dalam hitungan detik<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Perbedaan Waktu di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua kolom waktu mulai dan berakhir berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34462 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/td1.jpg\" alt=\"\" width=\"535\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk menghitung perbedaan waktu antara setiap waktu mulai dan waktu berakhir dan menampilkan hasilnya di kolom C hingga F:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindTimeDifference()\n    \n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 7\n        <span style=\"color: #008000;\">'calculate time difference in days<\/span>\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)\n        \n        <span style=\"color: #008000;\">'calculate time difference in hours<\/span>\n        Range(\" <span style=\"color: #ff0000;\">D<\/span> \" &amp; i) = (Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) * 24\n        \n        <span style=\"color: #008000;\">'calculate time difference in minutes<\/span>\n        Range(\" <span style=\"color: #ff0000;\">E<\/span> \" &amp; i) = (Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) * 24 * 60\n        \n        <span style=\"color: #008000;\">'calculate time difference in seconds<\/span>\n        Range(\" <span style=\"color: #ff0000;\">F<\/span> \" &amp; i) = (Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) - Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) * 24 * 60 * 60\n    <span style=\"color: #0000ff;\">Next<\/span> i\n    \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-34463\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/td2.jpg\" alt=\"VBA menghitung perbedaan waktu\" width=\"544\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sampai F menampilkan perbedaan waktu antara waktu mulai dan waktu berakhir dalam satuan yang berbeda.<\/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 VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-membandingkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan tanggal di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-hari-antara-dua-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung hari antara dua tanggal di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-mengonversi-string-ke-tanggal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana mengkonversi string ke tanggal di VBA<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut di VBA untuk menghitung selisih antara dua waktu: Sub FindTimeDifference() Dim i As Integer For i = 2 To 7 &#8216;calculate time difference in days Range(&#8221; C &#8221; &amp; i) = Range(&#8221; B &#8221; &amp; i) &#8211; Range(&#8221; A &#8221; &amp; i) &#8216;calculate time difference in hours Range(&#8221; D [&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 Selisih Waktu di VBA (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung perbedaan waktu antara dua sel di Excel menggunakan VBA, dengan beberapa 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\/perbedaan-waktu-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Selisih Waktu di VBA (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung perbedaan waktu antara dua sel di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T11:15:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/td1.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\/perbedaan-waktu-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/\",\"name\":\"Cara Menghitung Selisih Waktu di VBA (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T11:15:34+00:00\",\"dateModified\":\"2023-07-11T11:15:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung perbedaan waktu antara dua sel di Excel menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung selisih waktu di vba (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 Selisih Waktu di VBA (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara menghitung perbedaan waktu antara dua sel di Excel menggunakan VBA, dengan beberapa 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\/perbedaan-waktu-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Selisih Waktu di VBA (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung perbedaan waktu antara dua sel di Excel menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T11:15:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/td1.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\/perbedaan-waktu-vba\/","url":"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/","name":"Cara Menghitung Selisih Waktu di VBA (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T11:15:34+00:00","dateModified":"2023-07-11T11:15:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung perbedaan waktu antara dua sel di Excel menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perbedaan-waktu-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung selisih waktu di vba (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\/4393"}],"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=4393"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4393\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}