Dear mr bagus & jan raisin. Terimakasih atas bantuannya,masalah saya sudah terpecahkan
Maaf baru dibalas /regards irianto From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Bagus Sent: Wednesday, March 12, 2014 4:32 PM To: belajar-excel@yahoogroups.com Subject: Re: [***SPAM*** Score/Req: 06.50/5.0] [belajar-excel] if bertingkat berdasarkan kriteria Hai Irianto; Coba begini: =IF(OR(AND(B16="Normal",D16>C16,C16<TIME(12,0,0),D16>TIME(13,0,0)),AND(B16=" Shift 1",D16>C16,C16<TIME(10,0,0),D16>TIME(11,0,0)),AND(B16="shift 2",D16>C16,C16<TIME(18,0,0),D16>TIME(19,0,0)),AND(B16="shift 3",D16>C16,TIME(C16,C16,C16)<TIME(2,0,0),D16>TIME(3,0,0))),HOUR((D16-C16))*6 0+MINUTE(D16-C16)-60,24-HOUR(C16)*60-MINUTE(C16)+HOUR(D16)*60+MINUTE(D16)) Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: irianto <mailto:irianto.mand...@yahoo.com> To: belajar-excel@yahoogroups.com Sent: Wednesday, March 12, 2014 3:56 PM Subject: [***SPAM*** Score/Req: 06.50/5.0] [belajar-excel] if bertingkat berdasarkan kriteria [1 Attachment] Dear master.... Mohon bantuannya utk memecah kan kasus ini File terlampir.... /regard irianto
