mas stepahanus, Sedikit interest juga untuk rumus yang anda berikan, umumnya khan rumus tersebut digunakan untuk billing waktu. Nah bagaimana caranya didalam excel jika minimum 15 menit dikenakan Rp. 5000 dan ketika masuk menit ke 16 baru di hitung per menitnya.
regards Yanu -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Stephanus J Alex Taidri Sent: Wednesday, December 07, 2005 6:52 PM To: [email protected] Subject: RE: [ITCENTER] Mengalikan menit C1 =B1-A1 D1 =HOUR(C1) E1 =MINUTE(C1) F1 =((D1*60)+E1)*165 Have Fun :-) Regards, Stephanus J Alex Taidri BIT Education - Cisco Training Center http://edu.bitgroups.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yocky Wulantoro Sent: Wednesday, December 07, 2005 6:42 AM To: [email protected] Subject: [ITCENTER] Mengalikan menit a1=09:10:00 b1=10:15:00 c1=b1-a1 (format menit) d1=Rp165 x C1 Gimana caranya mengalikan c1 dengan Rp 165? kalikan dengan menitnya bukan dengan jamnya. kok hasilnya error terus ya? -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
