{"id":4861,"date":"2023-07-07T03:23:42","date_gmt":"2023-07-07T03:23:42","guid":{"rendered":"https:\/\/statorials.org\/id\/format-waktu-vba\/"},"modified":"2023-07-07T03:23:42","modified_gmt":"2023-07-07T03:23:42","slug":"format-waktu-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/format-waktu-vba\/","title":{"rendered":"Cara memformat waktu di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <strong>Format<\/strong> di VBA dengan argumen berikut untuk memformat waktu di Excel dengan cara tertentu:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>h<\/strong> : jam tanpa angka nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>hh<\/strong> : jam dengan angka nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> : menit tanpa angka nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>nn<\/strong> : menit dengan angka nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>s<\/strong> : detik tanpa angka nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>ss<\/strong> : detik dengan nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>AM\/PM<\/strong> : Tampilan AM\/PM<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara memformat waktu menggunakan VBA dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Format Waktu Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom tanggal\/waktu berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37974 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire1.png\" alt=\"\" width=\"526\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk memformat waktu di kolom A secara khusus dan menampilkan waktu yang diformat di kolom B hingga E:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFormatTime<\/span> ()\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> 8\n  Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">h<\/span> \")\n  Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">h:nn<\/span> \")\n  Range(\" <span style=\"color: #ff0000;\">D<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">h:nn:ss<\/span> \")\n  Range(\" <span style=\"color: #ff0000;\">E<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">h:nn:ss AM\/PM<\/span> \")\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=\" wp-image-37975 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire2-1.png\" alt=\"\" width=\"561\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B hingga E kini ditampilkan setiap saat di kolom A yang diformat dengan cara tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat menggunakan format pintasan <strong>Waktu Singkat<\/strong> , <strong>Waktu Sedang<\/strong> , dan <strong>Waktu Panjang<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFormatTime<\/span> ()\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> 8\n  Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">Short Time<\/span> \")\n  Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">Medium Time<\/span> \")\n  Range(\" <span style=\"color: #ff0000;\">D<\/span> \" &amp; i) = Format(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), \" <span style=\"color: #ff0000;\">Long Time<\/span> \")\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=\" wp-image-37976 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire3-1.png\" alt=\"\" width=\"566\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B hingga D kini ditampilkan setiap saat di kolom A yang diformat dengan cara tertentu.<\/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\/format-tanggal-vba-hh-hh-tttt\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menggunakan bb\/hh\/tttt sebagai format tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-persentase-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara memformat sel sebagai persentase<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pemformatan-bersyarat-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menerapkan pemformatan bersyarat ke sel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi Format di VBA dengan argumen berikut untuk memformat waktu di Excel dengan cara tertentu: h : jam tanpa angka nol hh : jam dengan angka nol n : menit tanpa angka nol nn : menit dengan angka nol s : detik tanpa angka nol ss : detik dengan nol AM\/PM : [&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 Memformat Waktu di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memformat waktu di 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\/format-waktu-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memformat Waktu di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memformat waktu di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/format-waktu-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T03:23:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire1.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\/format-waktu-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/format-waktu-vba\/\",\"name\":\"Cara Memformat Waktu di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T03:23:42+00:00\",\"dateModified\":\"2023-07-07T03:23:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memformat waktu di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/format-waktu-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/format-waktu-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/format-waktu-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memformat 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 Memformat Waktu di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara memformat waktu di 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\/format-waktu-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memformat Waktu di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara memformat waktu di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/format-waktu-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-07T03:23:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formulaire1.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\/format-waktu-vba\/","url":"https:\/\/statorials.org\/id\/format-waktu-vba\/","name":"Cara Memformat Waktu di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T03:23:42+00:00","dateModified":"2023-07-07T03:23:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memformat waktu di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/format-waktu-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/format-waktu-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/format-waktu-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memformat 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\/4861"}],"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=4861"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4861\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}