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

[µo°Ý] ®É¶¡¨î¼Æ­È­pºâªº°ÝÃD

[µo°Ý] ®É¶¡¨î¼Æ­È­pºâªº°ÝÃD

¥»©«³Ì«á¥Ñ renzhi2020 ©ó 2012-2-25 22:08 ½s¿è

½Ð°Ý¤j¤j ¦p¤U¹Ï¤@ ªº ®É¶¡¨î¤½¦¡ ­n«ç»ò¼g
¥d¦b24¤p«á ¤£·|­pºâ>.<"

1.jpg (46.79 KB)

1.jpg

®É¶¡.rar (1.95 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# renzhi2020

=IF((C12>TIME(7,30,0))*(C12<TIME(19,30,0)),TIME(12,0,0),IF(C12>TIME(19,30,0),C12-"19:30",1-"19:30"+C12))*24
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# renzhi2020

©w¸q¦WºÙ ®É¶¡=HOUR(Sheet1!$C$12)+MINUTE(Sheet1!$C$12)/60
D12=IF(®É¶¡>19.5,®É¶¡-19.5,IF(®É¶¡<7.5,4.5+®É¶¡,12))

TOP

¥»©«³Ì«á¥Ñ renzhi2020 ©ó 2012-2-25 23:07 ½s¿è

¦^´_ 3# register313

«D±`·PÁ¤G¦ì¤j¤jªº¦^ÂÐ:
¨Ï¥ÎHsieh sir ªº¤½¦¡ ¨S¦³Åã¥Ü®É¶¡¨î
¨Ï¥Îregister313 sir ªº¤½¦¡¥i¥¿õáÅã¥Ü
¦p¤U¹Ï

2.jpg (5.79 KB)

2.jpg

®É¶¡¨îºâªk.rar (2.17 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 4# renzhi2020
=MOD(IF((C12>TIME(7,30,0))*(C12<TIME(19,30,0)),TIME(12,0,0),IF(C12>TIME(19,30,0),C12-"19:30",1-"19:30"+C12)),1)*24
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh

³á³á~

OK¤F

¦A¦¸·PÁ ¤G¦ì¤j¤j~
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD