{"id":5309,"date":"2016-09-23T19:48:29","date_gmt":"2016-09-23T12:48:29","guid":{"rendered":"http:\/\/martianuswb.com\/?p=5309"},"modified":"2016-09-23T19:48:29","modified_gmt":"2016-09-23T12:48:29","slug":"libreoffice-calc-menghitung-rentang-waktu","status":"publish","type":"post","link":"https:\/\/martianuswb.com\/?p=5309","title":{"rendered":"LibreOffice Calc: menghitung rentang waktu"},"content":{"rendered":"

Dengan LibreOffice Calc, kita bisa menghitung panjang waktu tertentu, misalnya usia atau masa kerja dalam tahun, bulan, hari. Kali ini saya contohkan bagaimana menghitung usia dari tanggal lahirnya.<\/p>\n

Katakanlah ada seorang yang lahir tanggal 20 Maret 2011. Untuk menghitung usianya kita bisa gunakan fungsi DATEDIF.<\/p>\n

Pada contoh, pastikan sel tanggal (A3) dalam format date. Untuk mengetahui berapa tahun usianya kita masukkan perintah =DATEDIF(A3,TODAY(),”Y”)<\/strong><\/em><\/span>.<\/p>\n

\"Mencari<\/a>

Mencari usia dalam tahun<\/p><\/div>\n

Untuk mencari sisa bulan, kita masukkan perintah =DATEDIF(A3,TODAY(),”YM”)<\/strong><\/em><\/span><\/p>\n

\"mencari<\/a>

mencari usia dalam bulan<\/p><\/div>\n

Nah, untuk sisa harinya tinggal masukkan perintah =DATEDIF(A3,TODAY(),”MD”)<\/strong><\/em><\/span><\/p>\n

\"mencari<\/a>

mencari usia dalam hari<\/p><\/div>\n

Cukup mudah ‘kan? Silakan dicoba.<\/p>\n\n","protected":false},"excerpt":{"rendered":"

Dengan LibreOffice Calc, kita bisa menghitung panjang waktu tertentu, misalnya usia atau masa kerja dalam tahun, bulan, hari. Kali ini saya contohkan bagaimana menghitung usia dari tanggal lahirnya. Katakanlah ada… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1403,1265],"tags":[2044,1486,2045,1678,2043,2042],"class_list":["post-5309","post","type-post","status-publish","format-standard","hentry","category-libreoffice","category-sinau-linux","tag-bulan","tag-calc","tag-hari","tag-libreoffice","tag-tahun","tag-usia"],"_links":{"self":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5309"}],"version-history":[{"count":1,"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5309\/revisions"}],"predecessor-version":[{"id":5313,"href":"https:\/\/martianuswb.com\/index.php?rest_route=\/wp\/v2\/posts\/5309\/revisions\/5313"}],"wp:attachment":[{"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/martianuswb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}