Selasa, 17 November 2020

[belajar-excel] Formula Jam

 

Selamat sore guru semua
Mohon bantuannya mengenai formula selisih Jam jika Jam berbeda hari atau lebih kecil

terima kasih

__._,_.___

Posted by: harry budiman <sendtoharbud@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....

Minggu, 15 November 2020

[ExcelVBA] Pi Network Digital Cryptocurrency Will Be The Next Bitcoin And Could Be Worth Up To $200

 

Good Day everyone,

Have you heard of the Pi Network?
Unless you are deep in the world of cryptocurrency, the chances are you haven't heard of it.
But I am here to tell you why you need to be aware of this newcomer to the world of digital currency and how you can get started today.
Pi is a new digital currency startup and you can get in on this at the ground floor.
How many times do you wish you could have invested in Apple, Amazon, or Walmart way back when?
You see how much wealth you could have built if you only took the chance.
Here is your chance to get in on the next possible big thing, and it's easy to do.
Keep reading to learn all about the Pi Network and how to get started investing!

Pi Network was launched by a group of Stanford PHD students and looks set to be as good if not better than Bitcoin.
Mining cryptocurrency on your phone has always been battery depleting and not cost effective, however that has now changed with the launch of the Pi Network, a FREE mining software for your mobile phone!
Created by a group of Stanford University PHD students, this revolutionary new cryptocurrency is set to become one of the most popular in the world and YES! It could make YOU rich!
The Pi Network mines cryptocurrency off your phone using no battery power or data and only requires an internet connection to mine.
Users are encouraged to refer their friends and family to the program to earn more over time and the program recently hit over 9 Million registered Pioneers.

How Much Is Pi Worth?
The Pi Network cryptocurrency is currently worth nothing as it is in stage 2 development and has not yet launched on the blockchain, but a back-end marketplace already has users exchanging the currency for up to $10 a coin.
Some users have said that when the coin launches on exchanges, expected in 2021, it may reach a value close to that of Ethereum at $200 or possibly more!
This would mean if you had mined over 1000 coins on the Pi Network App, you would be sitting on a balance of $200,000 dollars.
To state how easy it is to earn Pi, I have invited just 20 friends so far, and have a balance of close to 10000 coins in little under one year and not all of my friends mined the coins!
Even if the Pi Network only hit a price of $25 per coin, that would still leave me with $250,000 profit!

How Do I Join This Amazing Program?
The best way to join the Pi Network is to download the app and install it on your phone.
You can download the app from the google/apple store and remember that the Pi team will never ask you for any information regarding your account or password and the app can be linked to Facebook so if you loose your phone, funds can still be accessed.

An invite code is required to join the network and you can use my code which is cakzxd and remember, the more people you invite, the more Pi you earn!

Will Mining End On The Pi Network?
As with many new cryptocurrency, Pi is currently mineable, however there is only a limited time to get into the program and mining may end for new members once the user-base reaches 10 million Pioneers.
Existing users will of course still be able to mine, however this will be at a reduced rate, possibly half what it was when you joined.

Can Developers Get In On The Action?
The Pi App has a cool Platform for Developers including the Pi SDK which enables developers to build applications that integrate with Pi currency and Pi Platform.
Another free feature of the development suite is the Pi Apps Developer Sandbox tool that helps developers test and visualize their apps on Pi Apps Platform using the Pi SDK

Key Points For The Pi Network
Remember, the Pi Network is FREE TO JOIN and you will make profit even if you mine just 10 coins!

Key Features include -
- Works on your mobile phone and does not drain your battery
- Secure, non-counterfeit-able and interoperable digital money
- The Pi App, available on both Google Play and App Store
- The Pi Node with Access to the Pi App from your computer
- Easy to use security at scale, without the electrical waste.

More Information?  Please visit us at
https://www.pinetworkapp.org
or
https://minepi.com/cakzxd

Bitcoin just boomed over $16K last week.
Some people achieved the crypto dream while others realized how ignoring the trend was a terrible mistake.
PI could be the next opportunity, It is a new digital currency developed by Stanford PhDs in 2019, with over 9million members worldwide today. It seems to follow the same pattern as Bitcoin in 2009.
At this stage, the PI network plan seems to just be "grow the numbers, test the system, and we will take it from there."


You just need to take one minute a day, give yourself a chance to get rich. PI is Zero risk, no investment, no credit card required
If you miss the bitcoin at an early stage, don't let this opportunity pass by again.
There's no reason not to join the  PI network and earn some tokens. Join now, or regret it later.
PI is a long term project, If you want to make money fast and take some risks, please visit the below subsite, This subsite will be updated weekly. It is going to provide you some idea on how to earn with ZERO or little investment to make money, Please visit us frequently.
https://www.pinetworkapp.org/free

On December 15, 2020 all yahoo group members will no longer be able to send or receive emails from Yahoo Groups.
If  you want to still receive those messages on how to invest in the crypto FREE and SAFE, Please join our new google group Great_Opptunity_Invest_Blockchain
You just need to send a blank email to l0731goibc+subscribe@googlegroups.com. Then you will get a reply from this group.
Please DO NOT click the button "Join This Group". But just reply it with another blank email again. You will be added to the group.
You will get the confirmed email message "You are now a member of the l0731goibc group".

 

Good Luck.

__._,_.___

Posted by: "dearapat1501@yahoo.com" <dearapat1501@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

.

__,_._,___
READ MORE....

Kamis, 05 November 2020

[belajar-excel] Fwd: File Bantu Hitung Lembur

 



---------- Forwarded message ---------
From: Abu Abdillaah <abuabdillaah99@gmail.com>
Date: Thu, Oct 15, 2020 at 4:30 PM
Subject: File Bantu Hitung Lembur
To: <milis-belajar-excel@googlegroups.com>


Dear Para Master,

Selamat beraktifitas,
Mohon bantuannya untuk kasus sebagai berikut:
Kami sedang membuat data bantu untuk perhitungan lembur dengan macro.
Saat ini sedang mengalami kesulitan untuk pembuatan data rekapnya (Sheet OT).
karena masih belajar buat macro (copas sana sini) mungkin ada skrip yang masih "belepotan".
(File terlampir)
Mohon bantuannya para master untuk skrip macro rekapnya seperti apa ya?

Terimakasih atas bantuan dan kerjasamanya.
Best regards,
Jatmiko

__._,_.___

Posted by: Abu Abdillaah <abuabdillaah99@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....

Bls: Re: ]] XL-mania [[ Conditional format hanya untuk data paling ujung

 

Wah, terimakasih banyak bang, sangat membantu .... Problem solved


Pada Rab, 4 Nov 2020 pada 5:59, HERIS PAMUNTJAR heris2001@yahoo.com [XL-mania]
<XL-mania@yahoogroups.com> menulis:
 

beginikah?


On Sunday, October 25, 2020, 11:07:22 AM GMT+7, Supriyadi supriyadi_sbm@yahoo.co.id [XL-mania] <xl-mania@yahoogroups.com> wrote:


 

dear all,

bagaimana ya rumus atau cara untuk conditional format, agar hanya data paling ujung di dalam satu baris yg berubah warna,
dan sebelumnya saya ucapkan terimakasih, untuk semua

Best Regards,

Supriyadi
Jadikan gambar sebaris

__._,_.___

Posted by: Supriyadi <supriyadi_sbm@yahoo.co.id>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com

.

__,_._,___
READ MORE....

Selasa, 03 November 2020

RE: ]] XL-mania [[ Conditional format hanya untuk data paling ujung

 

Mas Supriyadi

 

Caranya bagaimana itu Mas...? terimakasih sebelumnya

 

Salam

Aidil Irsyad Kari Mangkuto

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: 04 November 2020 04:59
To: XL-mania@yahoogroups.com
Subject: Re: ]] XL-mania [[ Conditional format hanya untuk data paling ujung

 

 

beginikah?

 

 

On Sunday, October 25, 2020, 11:07:22 AM GMT+7, Supriyadi supriyadi_sbm@yahoo.co.id [XL-mania] <xl-mania@yahoogroups.com> wrote:

 

 

 

dear all,

 

bagaimana ya rumus atau cara untuk conditional format, agar hanya data paling ujung di dalam satu baris yg berubah warna,

dan sebelumnya saya ucapkan terimakasih, untuk semua

 

Best Regards,

 

Supriyadi


Virus-free. www.avast.com

__._,_.___

Posted by: "Aidil Irsyad Kari Mangkuto" <aidilirsyad.karimangkuto@imail.co.id>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com

.

__,_._,___
READ MORE....

Re: ]] XL-mania [[ Conditional format hanya untuk data paling ujung

 

beginikah?


On Sunday, October 25, 2020, 11:07:22 AM GMT+7, Supriyadi supriyadi_sbm@yahoo.co.id [XL-mania] <xl-mania@yahoogroups.com> wrote:


 

dear all,

bagaimana ya rumus atau cara untuk conditional format, agar hanya data paling ujung di dalam satu baris yg berubah warna,
dan sebelumnya saya ucapkan terimakasih, untuk semua

Best Regards,

Supriyadi
Jadikan gambar sebaris

__._,_.___

Posted by: HERIS PAMUNTJAR <heris2001@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com

.

__,_._,___
READ MORE....

Minggu, 01 November 2020

[belajar-excel] File - Peraturan Milis belajar-excel

 


"PERATURAN MILIS belajar-excel"
-------------------------------

Milis belajar-excel dibuat agar menjadi komunitas / tempat berkumpulnya
para pemakai software microsoft excel, untuk saling berbagi pengetahuan
(sharing), diskusi dan tanya-jawab hal-hal yg menyangkut MS Excel.

Setting untuk posting di milis ini masih dipertahankan = "UnModerated"
(member dapat mengirim posting, tanpa melalui moderasi dan langsung
masuk ke message-list di milis).
Posting pertama & kedua dari member yg baru bergabung harus menunggu
approval dari moderators. Jika dinilai wajar, posting selanjutnya tidak
perlu approval lagi.

Hal ini adalah demi menjadikan milis lebih dinamis, posting tidak
tertunda, diskusi lebih hidup.

Tetapi konsekwensinya, kita sebagai members harus punya niat untuk
menjaga milis ini tetap bersih, enak diikuti, yaitu dengan TIDAK
mengirim posting berisi hal yg mubazir, yg di luar topik, yg "nyampah";
apalagi yg memicu timbulnya pertengkaran yg tidak perlu.

Setiap saat para Moderators akan melihat-lihat lagi msg list, dan akan
membersihkan message list dari posting sampah yg tidak perlu.

Untuk itu kita perlu kesepakatan sebagai berikut:

A. SANGAT DIHARAPKAN:
==================

(1)
Posting dari member berupa: share pengetahuan, pertanyaan, jawaban dan/
atau komentar dan tanggapan yg masih relevan dengan pertanyaan/posting;
semuanya harus sekitar atau ada hubungannya dengan Microsoft Excel.

(2)
Size Lampiran dlm rangka memperjelas kasus/penjelasan, agar diupayakan
tidak lebih dari 250KB, jika perlu dicompressed dulu.

(3)
Posting pertanyaan dialamatkan hanya kepada alamat milis, (jangan ke
alamat owner)

(4)
Semua mail dikemukakan secara santun, ceria, menyenangkan, boleh lucu,
saling menghormati, menjauhkan dari masalah SARA.

B. SANGAT TIDAK DIHARAPKAN:
========================

(1)
Mail yg isinya melecehkan, menghina fihak lain, berbahasa kasar, memicu
pertengkaran dsb.

(2)
Posting "too good to be true" misalnya "jualan" (MLM), spam, money game,
hoax, mail berantai dan iklan (tanpa lebihdulu mendapat ijin dari owner).

(3)
Cross-posting (mengirim 1 mail sekaligus kepada lebih dari satu milis /
address tujuan).

(4)
Mail yg ditulis dengan ukuran, bentuk/warna font dan cara yg di luar
kewajaran, sehingga menyulitkan pembacaan.

(5)
Mail tanpa judul/subject dan/atau tanpa isi, walaupun melampirkan penjelasan.

(6)
Menyertakan link yang merujuk kepada halaman yang berisi iklan produk /
informasi yang tidak berhubungan dengan Excel / pertanyaan.

C. LAIN LAIN:
========

Saran & Tips menulis mail / posting ke milis:
---------------------------------------------

(a)
Berikan subject yg isinya mewakili kasus yg akan ditulis.
Hindari subject yg tidak jelas dan terlalu general (misal "tolong",
"help", "tanya" "mohon pencerahan", dsb)

(b)
Ikuti Subject yg telah ada, (dengan meReply), hanya jika masalah yg akan
ditulis masih berkaitan.
Mengubah Subject (misal dgn menambah kata "Balasan" / "Solusi" /
"Tanggapan" dsb, hanya akan merusak 'Thread' (korelasi/kesinambungan)
suatu topik, oleh karena itu jangan dilakukan.

Jika anda akan mengajukan topik/kasus baru yg tidak berkaitan dengan
topik yg telah ada, buatlah Subject baru, dengan Compose / New Mail.
JANGAN dengan cara mereply subject yg ada lalu mengganti subjecnya.

(c)
Terutama pada posting pertanyaan/request, tuliskan masalah dengan jelas
di badan email. Penjelasan lebih rinci dapat ditulis pada lampiran.
Lampiran sedapat mungkin berupa workbook (file *.xls), dengan nama-file
yang spesifik.

(d)
Posting tanggapan/jawaban hendaknya ditulis secara 'top-posting' (di
ATAS "quoted mail" yg ditanggapi, demi mempermudah pembacaan.

'Quoted mail' tidak harus disertakan semua, cukup 1 atau maximal 2 mail
terdahulu.

(e)
Footer yg tidak perlu hendaknya dihapus dulu sebelum mail Anda kirimkan.

Mengenai OOT dan VOOT
---------------------
Di luar 3 jenis posting di atas, yi: DISKUSI yg berisi sharing,
pertanyaan, tanggapan) akan dianggap Out of Topic (OOT) atau bahkan
VOOT (very out of topic).

Kategory OOT akan dipertimbangkan kasus-demi-kasus dengan kriteria
"manfaat positif bagi komunitas kita".

Kategory OOT atas pertimbangan khusus, misalnya demi kepentingan yg
mendesak dan penting, atau demi "kemanusiaan", tidak didelete.
Jika tidak memenuhi kriteria akan didelete dengan atau tanpa pemberi-
tahuan kpd member.

Kategory VOOT, posting akan langsung didelete, pengirim akan diberi
teguran.

VOOT kedua dari pengirim yg sama akan menyebabkan member ybs didisabled
sementara kemampuan postingnya.

Kelanjutan dari suatu diskusi tanya-jawab, masih layak diposted ke milis,
misal hanya ucapan terima kasih atau pun sejenis konfirmasi bahwa suatu
solusi sudah diterima dan dapat dipakai dsb, ini dapat golongkan sbg OOT
yg masih layak tayang.

Kelanjutan pembicaraan yg sudah tidak relevan lagi bagi member lain,
dapat anda teruskan melalui 'japri' (jalur pribadi).

Kritik dan saran kepada milis 'belajar-excel'
--------------------------------------------
Kritik dan saran diluar masalah excel demi perbaikan milis ini dapat
disampaikan ke owner / moderators

Hak dan wewenang Moderators
---------------------------
Moderators berhak setelah mempertimbangkan hal-hal diatas untuk
memberikan kartu kuning atau langsung kartu merah dan/atau
mem-banned members yang melakukan pelanggaran rules milis ini.

Himbauan dari milis 'belajar excel' kpd members
-----------------------------------------------

Diharapkan para members terus meningkatkan pengetahuannya mengenai
kelaziman cara bermilis & ber-net-ria secara umum.

Perlu selalu disadari bahwa di dunia internet, sama dengan dunia kita
sehari hari.
Jika di dunia nyata kita mengenal "etika / ettiquettes", maka di net
ada semacam etika umum yg lazim disebut "nettiquette".

Kalau anda sering tidak mengindahkan "nettiquettes", tidak akan polisi
yg menangkap anda; tetapi lama-lama anda akan dijauhi banyak rekan,
karena mereka tentu merasa tidak nyaman ber-korespondensi dengan anda.

Sebagai Members of "milis belajar-excel" dan sebagai 'netter sejati',
anda tentu tidak suka kalau harus dicap sebagai "tidak nettis" yang
artinya setara dgn "tidak etis".

--------------------------------------------[rev: 13mar2010 / ctv]-----

revisi 2: tgl 02Des2013 / dwint
# penambahan point B.6.

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (199)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....