1. =IF(RIGHT(B2,2)=RIGHT(C2,2),(C2-B2)/100,IF(VALUE(RIGHT(B2,2))>VALUE(RIGHT(C2,2)),(((LEFT(C2,2)-LEFT(B2,2))-1&"30")/100),(((LEFT(C2,2)-LEFT(B2,2))&"30")/100)))
¬O¤£¬O²[¼Æ¦³°ÝÃD¯Z§Opºâ¥X²{°ÝÃD
2.§T¨ú²[¼Æn¦p¦ó¼g¤~¥i¥H¦Û°Ê¥[Á` =MID(D2,5,3)
¦]Ó¤H¤w·Q¤£¨ì£z¡A½Ð¦U¦ì«e½ú«üÂI°g¸g¡AÁÂÁÂ!!! |