Try this: A1 =Entry Time (Format HH:MM:SS) B1 =Finish Time (Format HH:MM:SS) A2 =Harga per minute (setelah melewati batas 15 min) C1 =B1-A1 D1 =HOUR(C1) E1 =MINUTE(C1) F1 =SECOND(C1) G1 =((D1*60)+E1+(F1/60))
Hasilnya adalah pada Field H1 sbb: H1 =IF(G1<=15,5000,((G1-15)*A2)+5000) Have fun :) Regards, Stephanus J Alex Taidri BIT Education - Cisco Training Center http://edu.bitgroups.com -----Original Message----- From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Yanu Triana Putra Sent: Thursday, December 08, 2005 9:12 AM To: ITCENTER@yahoogroups.com Subject: RE: [ITCENTER] Mengalikan menit 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 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.12/193 - Release Date: 12/6/2005 -- 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/