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

[µo°Ý] ½Ð±Ðexcel®É¶¡­pºâ°ÝÃD>

[µo°Ý] ½Ð±Ðexcel®É¶¡­pºâ°ÝÃD>

½Ð±Ð°ª¤â¦p¦ó­pºâ®É¶¡?

§Ú·Q¦b¡yD1Àx¦s®æ¡z¤¤¿é¤J±ý¤À°t¤§¡yÁ`¤ÀÄÁ¼Æ¡z
¦b¡yB1Àx¦s®æ¡z¤¤¿é¤J¡y°_©l®É¶¡¡z
µM«á¡A«ö©Ò¦³¡y®É¬q¡z¥­§¡¤À°t®É¶¡¡A¦A¨Ì¡y°_©l®É¶¡¡z»¼¼WÅã¥Ü

¹Ï¤ù1.gif (9.36 KB)

¹Ï¤ù1.gif

peter460191

b4=IF(ROW()=4,$B$1,B3)+$D$1/COUNTA($A$4:$A$13)/1440

TOP

b4=IF(ROW()=4,$B$1,B3)+$D$1/COUNTA($A$4A$13)/1440
ANGELA µoªí©ó 2011-7-13 11:31



§Ú¸Õ¹L.ªGµMok~~ ¦ý½Ð°Ý.. §A¬O¦p¦ó°µ¨ì§â ¼Æ­ÈÅܦ¨®É¶¡ªº ?
§Ú­è¤~¥H¼Ó¥Dªº°ÝÃD¤]¸Õ¤F¦n¦h¦¸..§Úı±oÃöÁä¦b©ó  260/10/1440
½Ð°Ý..³o­Ó 1440 ¬O¤°»òªFªF?
NeverTry , NeverNo !

TOP

1¤p®É=60¤À
1¤Ñ=24¤p®É
60*24=1440

TOP

¦^´_ 2# ANGELA

«D±`ÁÂÁÂANGELA ª©¥D
¤w¤F¸Ñ¤F!
3Q!
peter460191

TOP

¥»¤H¨ü±Ð¤F..
ÁÂÁª©¥Dªº»¡©ú..²{¦b¤F¸Ñ¬°¤°»ò·| ¥Î 1440
NeverTry , NeverNo !

TOP

¦^´_ 2# ANGELA


¦A½Ð±Ðª©¥D
­n§â®É¶¡¬í¼Æ>30¬íªº¶i¦ì¤@¤ÀÄÁ;<30¬íªº±Ë¥h¤@¤ÀÄÁ
¤½¦¡­n¦p¦ó¼g?
3Q!
peter460191

TOP

¦^´_ 7# peter460191


    =ROUND(A1*1440,)/1440

TOP

¥»©«³Ì«á¥Ñ peter460191 ©ó 2011-7-18 15:33 ½s¿è

¦^´_ 8# ANGELA


    ¦A¦¸«D±`ÁÂÁÂANGELA ª©¥D
§Ú¤w¤F¸Ñ¤F!
¦A½Ð°Ý¤@¤U!¤½¦¡¤¤ªº³rÂI¥Nªí¤°»ò·N«ä?
3Q!
peter460191

TOP

,«áÁÙ¦³¤@­Ó¤Þ¼Æ¡A§PÂ_4±Ë5¤Jªº¦ì¼Æ
¬Ù²¤ªº¼gªk¡A­n¼gÀ³¸Ó¬O¸É0
Kenny

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD