DOSYA İndirmek/Yüklemek için ÜCRETLİ ALTIN ÜYELİK Gereklidir!
Altın Üyelik Hakkında Bilgi
=IF(N2+2>IF((IF(AND((MINUTE(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60+HOUR(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60*60+SECOND(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0)))+30>=HOUR(M2)*60*60+MINUTE(M2)*60+SECOND(M2);MINUTE(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60+HOUR(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60*60+SECOND(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))-30<=HOUR(M2)*60*60+MINUTE(M2)*60+SECOND(M2));TRUE;FALSE))=TRUE;VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;6;0);"hata")>N2-2;VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;8;0);"hata")
Türker!Kod:
=IF(N2+2>IF((IF(AND((MINUTE(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60+HOUR(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60*60+SECOND(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0)))+30>=HOUR(M2)*60*60+MINUTE(M2)*60+SECOND(M2);MINUTE(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60+HOUR(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))*60*60+SECOND(VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;5;0))-30<=HOUR(M2)*60*60+MINUTE(M2)*60+SECOND(M2));TRUE;FALSE))=TRUE;VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;6;0);"hata")>N2-2;VLOOKUP(J2&K2&L2&O2;$A$2:$H$12;8;0);"hata")
=EÃER(VE((DAKİKA(DÜÃEYARA(J2&K2&L2&O2;$A$2:$H$12;5;0))*60+SAAT(DÜÃEYARA(J2&K2&L2&O2;$A$2:$H$12;5;0))*60*60+SANİYE(DÜÃEYARA(J2&K2&L2&O2;$A$2:$H$12;5;0)))+30>=SAAT(M2)*60*60+DAKİKA(M2)*60+SANİYE(M2);DAKİKA(DÜÃEYARA(J2&K2&L2&O2;$A$2:$H$12;5;0))*60+SAAT(DÜÃEYARA(J2&K2&L2&O2;$A$2:$H$12;5;0))*60*60+SANİYE(DÜÃEYARA(J2&K2&L2&O2;$A$2:$H$12;5;0))-30<=SAAT(M2)*60*60+DAKİKA(M2)*60+SANİYE(M2));EÃER(VE(DÜÃEYARA((J2&K2&L2&O2);$A$2:$H$12;6;0)+2>=N2;DÜÃEYARA((J2&K2&L2&O2);$A$2:$H$12;6;0)-2<=N2);DÜÃEYARA((J2&K2&L2&O2);$A$2:$H$12;8;0);"hata");YANLIÃ)