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))*60+MINUTE(D16-C16)-60,24-HOUR(C16)*60-MINUTE(C16)+HOUR(D16)*60+MINUTE(D16))
Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: irianto To: [email protected] 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
