ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§Q¥Î¨ç¼Æ§PÂ_¥Ì¯S¹Ï¤é´ÁÃC¦â

§Q¥Î¨ç¼Æ§PÂ_¥Ì¯S¹Ï¤é´ÁÃC¦â

·Q½Ð°Ý¦U¦ì¤j¤º°ª¤â
Start     ¬° ¶}©l®É¶¡
End       ¬°µ²§ô®É¶¡
Status  ¬°¥Ø«e®É¶¡

¦p¦ó­n±N¥kÃä¥Ì¯S¹ÏªºÃC¦â¶ñ¥¿½T
§Ú¬O·Q­n±N­ì¥»Åã¥Ü¥H¶g¬°³æ¦ìªº¨ç¼Æ§ó§ï¬°¤w¤Ñ¬°¥D
¦ý´N¬O¤£©ú¥Õ­ì²z¬O¤°»ò
§ï¤F¦Ñ¥b¤ÑÁÙ¬O®{³ÒµL¥\
¥H¤U¬O¨ä¤¤ÃC¦â°Ï¶ôªº¨ç¼Æ¼gªk

=IF(OR(AND($AI3<=AP$2-4,$AK3>=AP$2-4),AND($AI3<=AP$2,$AK3>=AP$2)),IF(AND($AK3<AP$2,$AJ3+5<AP$2),4,2),IF(OR(AND($AI3<=AP$2-4,$AJ3>=AP$2-4),AND($AI3<=AP$2,$AJ3>=AP$2)),1,0))

¦p¤U¹Ï


·P¿E¤£ºÉ
Jared

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD