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

®É¶¡¨ç¼Æ°ÝÃD?

®É¶¡¨ç¼Æ°ÝÃD?

¥»©«³Ì«á¥Ñ jumky ©ó 2013-5-3 15:29 ½s¿è

½Ð°Ý¦U¦ì¤j¤j,­YA1=15:24...B1¦p¦ó³]¨ç¼Æ¤½¦¡±NA1+1¤p®É?(¸Ô¦pªþ¥ó Book2.rar (1.68 KB) )

¦^´_ 1# jumky

B1=A1+TIME(1,0,0)  ©Î =A1+1/24

B1³]©w®æ¦¡¤Æ±ø¥ó¦p¤U
   

TOP

B1 =A1+1/24

EXCEL ªº¤é´Á»P®É¶¡Æ[©À¬°¡A¤é´Á(©Î¤Ñ¡B¤é)¬°¾ã¼Æ³¡¤À¡A®É¶¡¬°¤p¼Æ³¡¤À¡A
¨Ò¦p
1¤p®É´N¬O 1/24
1¤ÀÄÁ´N¬O 1/24/60
1¬íÄÁ´N¬O 1/24/60/60

NOW() ¨ç¼Æ¬°¥Ø«e¤é´Á+®É¶¡
¨ú¥Ø«e®É¶¡¤½¦¡¬° MOD(NOW(),1) ¥ÎMOD(,1)¨ú¥X¤p¼Æ³¡¤À¬°®É¶¡

Àx¦s®æ­nÅÜÃC¦â´N»Ý­n§Q¥Î ³]©w®æ¦¡¤Æ±ø¥ó ¤è¦¡¨Ó³B²z
¿ï¥Î¤½¦¡³B²z¤è¦¡
=AND(MOD(NOW(),)>=A1, MOD(NOW(),)<=B1)
³]©wÃC¦â¡A¿ï¥Î¬õ¦â
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-5-3 16:40 ½s¿è

¦^´_ 1# jumky
½Ð°Ñ¦Ò
1¡B¦bB1Àx¦s®æ¿é¤J¤½¦¡      =A1+TIME(1,0,0)
2¡B¦b¡u³]©w®æ¦¡¤Æªº±ø¥ó¡v--¡u·s¼W±ø¥ó¡v¡A³]©w¡uÀx¦s®æ­È¡v¡u¤p©ó¡v¡A¤½¦¡Äæ¿é¤J ¡unow()¡v¤§«á¡A®æ¦¡¶µ¥Ø¿ï¾Ü±z­nªº¦rÅéÃC¦â§Y¥i¡C
µù¡G¨S·Q¨ì¦^¬M¹Lµ{¤¤¤w¦³°ª¤â¦^µª¤F

TOP

ÁÂÁÂaer¤j¤j,ML089¤j¤j,p212¤j¤j..ÁÂÁ§A­Ì~À°¤F¤j¦£..^^ÁÂÁÂ

TOP

¦^´_ 5# jumky


    ½Ð°Ý¦U¦ì¤j¤j,¦pªGB1­n³]®æ¦¡¤Æ³]©w=¹q¸£®É¶¡¦pªG¦bA1»PB1¤§¶¡ªº¸Ü¦r«¬´NÅã¥Ü¬õ¦â....¦pªG¹q¸£®É¶¡¤£¦bA1»PB1®É¶¡¤§¤º´NÅã¥Ü¶Â¦â...¸Ó¦p¦ó³]..?

TOP

B1 ®æ¦¡¤Æ±ø¥ó
¤½¦¡ =AND(MOD(NOW(),1)>=A1,MOD(NOW(),1)<=B1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


    ML089¤j¤j,ÁÂÁ±z.OK¤F,¤Ó·PÁ±z¤F^^..½Ð°Ý¤@¤U¤½¦¡¸Ì,1¬Oªí¥Ü¤@¤p®Éªº·N«ä¶Ü?¦pªG¬O¤@­Ó¥b¤p®É...¬O§_´N­n§ï¦¨1.5?
¥t¥~¤£À´¬°¤°»ò§Ú·Ó¨ä¥L¤j¤jªº°µªk..¿ïÀx¦s®æªº­È....¥Î¤¶©ó...«oµLªkÅܬõ¦â....?

TOP

¦^´_ 8# jumky
B1 ®æ¦¡¤Æ±ø¥ó
¤½¦¡ =AND(MOD(NOW(),1)>=A1,MOD(NOW(),1)<=B1)

NOW() ¬O¹q¸£¥Ø«eªº ¤é´Á+®É¶¡¡A¤é´Á¬O¾ã¼Æ³¡¦ì¡A®É¶¡¬O¤p¼Æ³¡¦ì
MOD(NOW(),1) ¬O¨ú1ªº¾l¼Æ¡A¤]´N¬O¤p¼Æ³¡¦ì¡A¤]´N¬O®É¶¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089


    ¤F¸Ñ..ÁÂÁÂML089¤j¤j¸Ô²Óªº¸Ñ»¡....THANK YOU:D

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD