terima kasih pak Wahyudi and its work
________________________________ Dari: "Wahyudi, Hery UTAS" <[email protected]> Kepada: [email protected] Dikirim: Senin, 10 September 2012 16:17 Judul: RE: [belajar-excel] menghitung lembur hari libur Ups… Salah [AT8] =SUM(IF((M8-7)>1,1,IF((M8-7)>0,M8-7,0)),IF((AA8-7)>1,1,IF((AA8-7)>0,AA8-7,0))) CMIIW Salam Hangat dan Jabat Erat From:[email protected] [mailto:[email protected]] On Behalf Of Wahyudi, Hery UTAS Sent: Monday, September 10, 2012 3:58 PM To: [email protected] Subject: RE: [belajar-excel] menghitung lembur hari libur [AT8]=SUM(AA8,M8)-AS8 CMIIW From:[email protected] [mailto:[email protected]] On Behalf Of indria pie Sent: Monday, September 10, 2012 3:31 PM To: [email protected] Subject: [belajar-excel] menghitung lembur hari libur dear Suhu Excel saya punya permasalahan dalam menghitung lembur hari libur seperti file terlampir, mohon bantuannya formula apa yang harus saya gunakan untuk isi cell AT8 (lembur "L2") trims -snupy-
