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

[µo°Ý] ½Ð°Ý¥ý¶i²[¼Æ°ÝÃD

[µo°Ý] ½Ð°Ý¥ý¶i²[¼Æ°ÝÃD

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§O­pºâ¥X²{°ÝÃD
2.§T¨ú²[¼Æ­n¦p¦ó¼g¤~¥i¥H¦Û°Ê¥[Á`  =MID(D2,5,3)

¦]­Ó¤H¤w·Q¤£¨ì£z¡A½Ð¦U¦ì«e½ú«üÂI°g¸g¡AÁÂÁÂ!!!

²[¼Æ°ÝÃD.zip (1.68 KB)

danny

ÁÂÁÂ¥ý¶i¦^µª  ¯uªº¥i¥H ¯uªº¤Ó·PÁ£z
ÁÂÁÂ!!
danny

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD