]] XL-mania [[ Digest Number 2398

Microsoft Excel Community

Messages In This Digest (2 Messages)

1a.

Re: Menghitung Absen Kehadiran Karyawan From: PT. Cosyindo Teknik

2a.

Re: Laporan Detail Stock Barang - FIFO From: Loheng Stone

View All Topics | Create New Topic

Messages

1a.

Re: Menghitung Absen Kehadiran Karyawan

Posted by: "PT. Cosyindo Teknik" ptcostek.document@gmail.com   adysumadio

Fri May 18, 2012 7:49 pm (PDT)

Oval: 1Coba coba kasih solusi :

Oval: 2Absen.JPG

1. Mungkin format tanggal di kolom "C" disamakan terlebih dahulu saya
lihat di row 3 & 4 menggunakan format dd/mm/yy time namun di kolom row 5 dst
menggunakan format mm/dd/yyyy time.

2. Setelah format tanggal disamakan dengan dd/mm/yyy time kita tinggal
copy di kolom tanggal menggunakan formula "=C3"(format nya date), dikolom
Absen masuk dan pulang menggunakan formula "=C16" (format nya time).

Demikian dari saya jika kurang berkenan mohon koreksi dari para pakar XL...

Regards

Ady Sumadio

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf
Of Ria Anggeraini
Sent: 15 Mei 2012 18:55
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Menghitung Absen Kehadiran Karyawan

Dear para suhu excel sekalian..

Saya ada masalah dengan memindahkan data Absen Masuk dan Absen Pulang
Karyawan seperti tabel terlampir.

Mohon bantuannya, dung.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.

Re: Laporan Detail Stock Barang - FIFO

Posted by: "Loheng Stone" lohengstone@yahoo.com   lohengstone

Fri May 18, 2012 7:50 pm (PDT)

kalo tidak salah penjabarannya seperti ini ...

Salam

Loheng

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

Recent Activity

•  37
  New Members

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! Groups

Parenting Zone

Tips for a happy,

healthy home

Yahoo! Groups

Small Business Group

Share experiences

with owners like you

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Delay pada posting disebabkan sibuknya momods dan leletnya        |
| koneksi dengan ind***t. bwakakakaka....
+-------------------------------------------------------------------+
| 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.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              |
+-------------------------------------------------------------------+

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe