Trims Mr Kid..saya coba dulu ya. Warm Rgds, ALEXANDER ferry...@yahoo.com Insanity is doing the same over & over again and expecting a different result <Einstein>
"'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: >HaiAlexander,Padasheetdataabsensi1.cellF2diberiformula:=IFERROR(INT(D2*1),DATE(MID(D2,FIND(,D2)-4,4),LEFT(D2,FIND(/,D2)-1),MID(LEFT(D2,FIND(/,D2,4)-1),FIND(/,D2)1,3)))aturformatcells-tabNumber-pilihDatecopykebawah2.cellG2diberiformula:=TIMEVALUE(RIGHT(D2,11))aturformatcells-tabNumber-pilihTimePadasheetrekapnya(selalumengambilyangpertamadi-entri),padacellE5diberiarrayformula:=MIN(IF((development!$C$2:$C$92=$B5)*(development!$F$2:$F$92=LOOKUP(9^9,$E$3:E$3))*(development!$E$2:$E$92=E$4),development!$G$2:$G$92))aturformatcells-tabNumber-pilihCustom-isiditextbox:h:mm:ssAM/PM;;lalutekanOKcopykekanandankebawah(keseluruhcellhasil)Wassalam,Kid.2014-08-080:56GMT10:00ferryreynoldaferry...@yahoo.com[belajar-excel]belajar-excel@yahoogroups.com: > >DearBe-excel,Mohonbantuanuntukrumusanrekapabsensihorisontalkekananseperticontohdisheethasilnamapertama,fileterlampir.terimakasih--WarmRegards,AlexanderPostedby:Mr.Kidmr.nmkid@gmail.comReplyviawebpostReplytosenderReplytogroup<ahref="https://groups.yahoo.com/neo/groups/belajar-excel/conversations/newtopic;_ylc=X3oDMTJma2M1cGNoBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE0MDc2MjI5NjQ-"style="text-decoration:none;color:#
