{"id":1705,"date":"2023-11-10T17:00:39","date_gmt":"2023-11-10T17:00:39","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/"},"modified":"2023-12-06T06:16:24","modified_gmt":"2023-12-06T06:16:24","slug":"waktu-saat-ini-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/","title":{"rendered":"Bagaimana cara mendapatkan waktu saat ini di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-354736679\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk mendapatkan waktu saat ini di Excel menggunakan rumus, Anda perlu menggunakan fungsi SEKARANG di Excel bersama dengan fungsi TRUNC. Dengan dua fungsi ini Anda bisa mendapatkan waktu saat ini dalam sebuah sel. Namun, Anda perlu memahami bahwa SEKARANG adalah fungsi volatil yang diperbarui setiap kali sheet Anda diperbarui. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79372\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"waktu saat ini di excel\" width=\"498\" height=\"302\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus untuk mendapatkan waktu saat ini di Excel<\/h2><p> Anda dapat menggunakan langkah-langkah berikut:<\/p><ol type=\"1\"><li> Pertama, di dalam sel, masukkan fungsi SEKARANG (sekarang Anda tidak perlu menentukan argumen apa pun).<\/li><li> Selanjutnya masukkan operator minus.<\/li><li> Sekarang masukkan fungsi TRUNC.<\/li><li> Setelah itu, di TRUNC, masukkan fungsi SEKARANG.<\/li><li> Terakhir, tutup fungsi TRUNC dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79373\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-obtenir-lheure-actuelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus-untuk-mendapatkan-waktu saat ini\" width=\"568\" height=\"278\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=NOW()-TRUNC(NOW())<\/code><\/pre><h2 class=\"wp-block-heading\"> Bagaimana cara kerja rumus ini?<\/h2><p> Excel menyimpan tanggal sebagai bilangan bulat dan waktu sebagai nilai desimal. Sekarang ketika Anda memasukkan fungsi SEKARANG ke dalam sel, ia mengembalikan tanggal dan waktu saat ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79374\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-formule-maintenant.png\" sizes=\"auto, \" srcset=\"\" alt=\"sekarang-formula\" width=\"679\" height=\"190\"><\/figure><\/div><p> Namun untuk memahami rumus ini, Anda perlu membaginya menjadi dua bagian. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79375\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formule-maintenant-et-tronc.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus sekarang-dan-potong\" width=\"551\" height=\"158\"><\/figure><\/div><p> Pada bagian pertama, kita memiliki fungsi SEKARANG yang mengembalikan tanggal dan waktu saat ini (tanggal dalam bilangan bulat dan waktu dalam desimal). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79376\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-premiere-partie-a-maintenant-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"bagian-pertama-sekarang-memiliki-rumusnya\" width=\"558\" height=\"218\"><\/figure><\/div><p> Di bagian kedua kita memiliki fungsi SEKARANG lagi tetapi dibungkus dengan TRUNC. Fungsi TRUNC menghapus seluruh bagian dari nilai yang dikembalikan oleh SEKARANG. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79377\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-deuxieme-partie-a-une-formule-tronconique.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus bagian kedua\" width=\"511\" height=\"272\"><\/figure><\/div><p> Dari hasil bagian pertama, Anda mendapatkan tanggal dan waktu keduanya. Dan dari hasil bagian kedua, Anda hanya punya tanggalnya saja. Dan itulah mengapa Anda hanya mendapatkan hasil waktu ketika Anda berada dalam waktu satu detik dari hasil pertama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-date-et-heure-moins-date-egale-a-lheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"tanggal-dan-waktu-dikurangi-tanggal-sama dengan-waktu\" width=\"482\" height=\"106\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Poin penting<\/h2><ul><li> SEKARANG adalah fungsi yang mudah berubah, dan akan berubah saat Anda memperbarui apa pun di spreadsheet Anda. Anda juga dapat mengonversi rumus menjadi nilai menggunakan salin dan tempel khusus.<\/li><li> SEKARANG menunjukkan waktu berdasarkan jam berapa Anda berada di sistem Anda. <\/li><\/ul><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/heure-actuelle.xlsx\" rel=\"nofollow\">Unduh<\/a> <\/p><\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Lebih banyak formula<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-jam-tepat-waktu\/\">Tambahkan jam ke waktu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-menit-ke-waktu\/\">Tambahkan menit ke waktu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghitung-perbedaan-waktu\/\">Hitung perbedaan waktu antara dua jam di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-format-waktu\/\">Ubah format waktu di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/waktu-militer\/\">Waktu Militer (Dapatkan dan Kurangi) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-dan-waktu-terpisah2\/\">Pisahkan tanggal dan waktu di Excel<\/a><\/li><\/ul><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">daftar 100+ rumus Excel (dasar + lanjutan)<\/a><\/p><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1705","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara mendapatkan waktu saat ini di Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk mendapatkan waktu saat ini dalam sel. Mari kita periksa ini\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mendapatkan waktu saat ini di Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk mendapatkan waktu saat ini dalam sel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/\",\"name\":\"Bagaimana cara mendapatkan waktu saat ini di Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\",\"datePublished\":\"2023-11-10T17:00:39+00:00\",\"dateModified\":\"2023-12-06T06:16:24+00:00\",\"description\":\"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk mendapatkan waktu saat ini dalam sel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mendapatkan waktu saat ini di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mendapatkan waktu saat ini di Excel? - Penasihat Excel","description":"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk mendapatkan waktu saat ini dalam sel. Mari kita periksa ini\u2026","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:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mendapatkan waktu saat ini di Excel? - Penasihat Excel","og_description":"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk mendapatkan waktu saat ini dalam sel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/","url":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/","name":"Bagaimana cara mendapatkan waktu saat ini di Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png","datePublished":"2023-11-10T17:00:39+00:00","dateModified":"2023-12-06T06:16:24+00:00","description":"Tutorial ini akan mengajari kita cara menulis rumus Excel untuk mendapatkan waktu saat ini dalam sel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-heure-actuelle-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/waktu-saat-ini-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mendapatkan waktu saat ini di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1705"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1705\/revisions"}],"predecessor-version":[{"id":2530,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1705\/revisions\/2530"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}