Dear Riska,
Untuk data time dengan kondisi time akhir < time awal, maka perlu ditambah 1.
Formula bisa disusun : (pada E3)
=D3-C3+(D3<C3)
Regards,
Kid.
Dear pakar XL
bagaimana ya caranya menghitung jam kerja karyawan?
Karena kalo dihitung manual tidak bisa. berikut contohnya.
Mohon bantuannya, terimakasih.
Regards,
Riska Wahyu N.
Ce message x000E9;lectronique et tous les fichiers attachx000E9;s qu'il contient sont confidentiels et destinx000E9;s exclusivement x000E0; l'usage de la personne x000E0; laquelle ils sont adressx000E9;s. Si vous avez rex000E7;u ce message par erreur, merci de le retourner x000E0; son x000E9;metteur. Les idx000E9;es et opinions prx000E9;sentx000E9;es dans ce message sont celles de son auteur, et ne reprx000E9;sentent pas nx000E9;cessairement celles de DANONE ou d'une quelconque de ses filiales. La publication, l'usage, la distribution, l'impression ou la copie non autorisx000E9;e de ce message et des attachements qu'il contient sont strictement interdits.
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of DANONE or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
| wooHoooOoooo!!! "mengapa boss benci chart anda" mau dicetak lagi! |
| insanbiasa : "member 17,000++ yang beli buku mengapa boss benci |
| chart anda cuma segituhh? pokoknya™ yang nggak beli: BANNED :D :D |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 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.friendster.com/xlmania atau... |
| 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 |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário