¦p¦ó¥ÎExcel­pºâ¤u®É¡A»Ý¦©°£¥ð®§®É¶¡

ron1983

°²³]§Ú­nZ²£½u
¶}©l®É¶¡14:20
§¹¦¨®É¶¡19:20

"¶}©l®É¶¡¸ò§¹¦¨®É¶¡¨Ã¨S¦³¤@©w"

¤¤¶¡¦³¥|­Ó®É¶¡¬O¥ð®§®É¶¡
10:00~10:10
12:00~13:00
15:00~15:10
17:20~18:00


F2 ¿é¤J¶}©l®É¶¡

G2 ¿é¤Jµ²§ô®É¶¡

¦bH2 Åã¥ÜÁ`¦@¤u§@®É¶¡¥H¤À¬°³æ¦ì

½Ð°ÝEXCELªº¤½¦¡À³¦p¦ó¼g©O?

­n¥i¥H¦Û°Ê¦©°£¥ð®§®É¶¡®@

©Î¬O¦³¤°»ò¤è¦¡¥i¥Hª½±µ¦bEXCEL³B²z

­«ÂI¦b¤½¦¡½T»{¤§«á§Ú¥u»Ý¿é¤J¶}©l¸ò§¹¦¨®É¶¡

Á`¤u§@®É¼Æ·|EXCEL¦Û¤v­pºâ

³Â·Ð¤j¤jÅo~

ANGELA

¦^´_ 1# ron1983

¤£§¹¬ü;¸Õ¸Õ.

ron1983

¦^´_ 2# ANGELA


    sorry~§ÚÅv­­¥Ø«e¤£¨¬~¥i¥H³Â·Ð±H¨ìªº«H½c¶Ü?[email protected]

ron1983

SORRY~·PÁ¤j®aªºÀ°¦£~¤U¦¸§Ú·|°O±oªþexcelÀÉ~

PD961A

°²³]§Ú­nZ²£½u
¶}©l®É¶¡14:20
§¹¦¨®É¶¡19:20

"¶}©l®É¶¡¸ò§¹¦¨®É¶¡¨Ã¨S¦³¤@©w"

¤¤¶¡¦³¥|­Ó®É¶¡¬O¥ð®§ ...
ron1983 µoªí©ó 2010-11-2 09:29

     ¦p¦ó¥ÎExcel­pºâ¤u®É¡A»Ý¦©°£¥ð®§®É¶¡
    http://gb.twbts.com/index.php?topic=8663.0

ron1983

¦^´_ 5# PD961A


    ·PÁ¤j¤jªºÀ°¦£~³o¤@½g§Ú¤@¶}©l´N¦³°Ñ¦Ò~¥i¬O¦]¬°²Ä¤@¦¸¨Ï¥Î~©Ò¥H¤£¼ô±x~¦b§ä¨ìªº¸ê°T¨Ã¤£§¹¾ã¤~·|¤Sµo°Ý~

074063

¥i¥H¤À¨É¶Ü [email protected]

ML089

¦^´_ 1# ron1983

H2 =SUMPRODUCT(LOOKUP(ROW(INDIRECT(ROUND(F2*1440,0)&":"&ROUND(G2*1440-1,0))),{0,"8:00","10:00","10:10","12:00","13:00","15:00","15:10","17:20","18:00"}*1440,{0,1,0,1,0,1,0,1,0,1}))