ªð¦^¦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

¦^´_ 1# danny001


    1.¥i¥H¥Î­Ó¤ñ¸û²³æªº°µªk  

E2: =INT(C2/100)+RIGHT(C2,2)/60-INT(B2/100)-RIGHT(B2,2)/60
E3: =INT(C3/100)+RIGHT(C3,2)/60-INT(B3/100)-RIGHT(B3,2)/60

2. =VALUE(MID(D2,5,3))
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD