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

¦p¦ó±N¶W®É¤u§@®É¶¡­pºâ¬°¤p®É

¦p¦ó±N¶W®É¤u§@®É¶¡­pºâ¬°¤p®É

¦U¦ì«e½ú, ¦p¦ó±NÁ`¦@¶W®É¤u§@¤F¦h¤Öªº®É¶¡, ­pºâ¬°¤p®É?
½Ð¬ÝªþÀÉ Over Time.rar (8.09 KB)

¦^´_ 1# Qin


©w®É¤u§@®É¶¡8 ¤p®É
¥ð®§1®É
±ßÀ\30¤ÀÄÁ  
¦p¦ó°Ï¤À?

§â ¤u§@®É¶¡ »P ¥[¯Z®É¶¡(¤p®É) ª½±µºâ´X­Ó¿é¤J¨ìÀɮ׸Ì
¥D­n¬O¤£¤F¸Ñ«ç»òºâ?

TOP

¦^´_ 2# register313

¨C¤Ñ¤u§@®É¶¡¬°8¤p®É, ¤ÈÀ\®É¶¡¬°1¤p®É (¦@¤E¤p®É) , ¦pªG¤u§@¦Ü±ß¶¡¤K®É©Î¥H¤W±N¦³30¤ÀÄÁªº±ßÀ\®É¶¡,
¦pªG¥u¤u§@¦Ü±ß¶¡7~8pm ¬O¨S±ßÀ\©Î¥ð®§®É¶¡ªº (©Ò¥H¤u§@¦Ü7pm ÄÝ¥[¯Z¤F1¤p®É, 8pm ´NÄÝ¥[¯Z¤F2¤p®É)
¦pªG¤u§@¦Ü9pm ´N¶·¦©°£¥ÎÀ\ªº30¤ÀÄÁ, ©Ò¥H¥[¯Z®É¶¡´Nºâ2¤p®É30¤À.

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-1-20 00:09 ½s¿è

¦^´_ 3# Qin

©|¦³¦h¨Æ¥¼©ú
(1)¤W¯Z®É¶¡¥ý¥H9:00°_ºâ(´£¦­©Î©µ«á¤W¯Z¦p¦ó³B²z)
(2)¤W¯Z®É¶¡¥¼¹F30¤À¤@²v±Ë¥h

E7=HOUR(D7)-10+IF(MINUTE(D7)>=30,0.5,0)   
F7=IF(E7>9,E7-8-0.5,0)

¥ý¬Ý¬Ý¥i¤£¥i¥H,­Y»Ý­×¥¿¦A»¡©ú

TOP

¤£¦Ò¼{¤W¤U¯Zªº¿ð¨ì¦­°h¡C¤]¤£¥H9:00¬°¤W¯Z°_©lÂI¡C¥H¹ê»Ú¤W¯Z®É¶¡¬°·Ç¡C
e7=FLOOR(D7-C7,0.5/24)-(1+(D7>20/24)*0.5)/24
f7=MAX((E7*24-8),0)

TOP

¦^´_ 4# register313

©|¦³¤@ºÃ°Ý½Ð«üÂI
Over Time 1.rar (9.01 KB)

TOP

¦^´_ 6# Qin

§Ñ¤F­n¦©°£©w®É¤u§@ªº8¤p®É
  H8+I8-8¤p®É-J8=2.5¤p®É

TOP

¦^´_ 4# register313

§Ñ¤F­n¦©°£©w®É¤u§@ªº8¤p®É
  H8+I8-8¤p®É-J8=2.5¤p®É

TOP

¦^´_ 7# Qin

K8=H8+I8/60-8-IF(J8="-",0,MINUTE(J8)/60)

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD