{"id":5035,"date":"2023-07-04T19:33:33","date_gmt":"2023-07-04T19:33:33","guid":{"rendered":"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/"},"modified":"2023-07-04T19:33:33","modified_gmt":"2023-07-04T19:33:33","slug":"cara-memasukkan-waktu-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/","title":{"rendered":"Cara memasukkan waktu di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk memasukkan nilai waktu di Excel dalam format tertentu adalah dengan menggunakan fungsi <strong>Format Sel<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara memasukkan waktu di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah Anda memiliki kumpulan data di Excel yang berisi nama-nama berbagai karyawan di sebuah perusahaan dan Anda ingin memasukkan waktu mereka tiba di tempat kerja pada hari tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39256 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entrezheure1.png\" alt=\"\" width=\"472\" height=\"390\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah Anda ingin memasukkan nilai waktu dalam format seperti <strong>6:15 AM<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memastikan bahwa Excel menampilkan nilai waktu yang Anda masukkan dalam format spesifik ini, sorot rentang sel <strong>B2:B13<\/strong> , lalu klik kanan, lalu klik <strong>Format Sel<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39257 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entreztime2.png\" alt=\"\" width=\"492\" height=\"620\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Waktu<\/strong> di kotak Kategori, lalu klik format waktu di kotak <strong>Tipe<\/strong> yang mewakili format waktu yang ingin Anda gunakan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya kita klik <strong>jam 13.30<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39258 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entreztime3.png\" alt=\"\" width=\"572\" height=\"569\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang kita bisa mengetikkan <strong>6:15<\/strong> ke dalam sel <strong>B2<\/strong> dan itu akan ditampilkan dengan benar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39259 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entreztime4.png\" alt=\"\" width=\"474\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian dapat memasukkan semua waktu check-in untuk setiap karyawan dan semuanya akan diformat dengan cara yang benar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39260 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entreztime5.png\" alt=\"\" width=\"511\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin waktu juga menampilkan jumlah detik, Anda perlu memilih format waktu lain menggunakan fungsi <strong>Format Sel<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat mengklik format yang ditampilkan sebagai <strong>1:30:55 PM<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39262 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entrerheure6.png\" alt=\"\" width=\"545\" height=\"559\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , detik juga akan ditampilkan setiap kali:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39263 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entreztime7.png\" alt=\"\" width=\"457\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Silakan memilih format waktu yang Anda inginkan menggunakan fitur <strong>Format Sel<\/strong> Excel.<\/span><\/p>\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\/excel-kurangi-menit-dari-waktu\/\" target=\"_blank\" rel=\"noopener\">Cara mengurangi menit dari waktu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/format-cap-waktu-excel-milidetik\/\" target=\"_blank\" rel=\"noopener\">Cara Memformat Waktu dalam Milidetik di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengubah-waktu-desimal-menjadi-jam-menit\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah waktu desimal menjadi jam dan menit di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk memasukkan nilai waktu di Excel dalam format tertentu adalah dengan menggunakan fungsi Format Sel . Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik. Contoh: Cara memasukkan waktu di Excel Katakanlah Anda memiliki kumpulan data di Excel yang berisi nama-nama berbagai karyawan di sebuah perusahaan dan Anda ingin memasukkan waktu mereka tiba [&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 Memasukkan Waktu di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memasukkan nilai waktu di Excel, 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\/cara-memasukkan-waktu-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memasukkan Waktu di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memasukkan nilai waktu di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T19:33:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entrezheure1.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\/cara-memasukkan-waktu-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/\",\"name\":\"Cara Memasukkan Waktu di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T19:33:33+00:00\",\"dateModified\":\"2023-07-04T19:33:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memasukkan nilai waktu di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memasukkan waktu 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 Memasukkan Waktu di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara memasukkan nilai waktu di Excel, 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\/cara-memasukkan-waktu-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memasukkan Waktu di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara memasukkan nilai waktu di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-04T19:33:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entrezheure1.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\/cara-memasukkan-waktu-di-excel\/","url":"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/","name":"Cara Memasukkan Waktu di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T19:33:33+00:00","dateModified":"2023-07-04T19:33:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memasukkan nilai waktu di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cara-memasukkan-waktu-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memasukkan waktu 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\/5035"}],"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=5035"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5035\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}