- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 11# Cyssuc
º¥ý, ¥Î¨Ó°µpºâªº¦¡¤l¤¸¯À,¤£«Øij¤å¦r¦Ó³Ì¦n¬Oµ¹¼ÆÈ,
«Øij§A±Ä¥Î =IF(TIME(16,0,0)<G96,17,...¦Ó«D =IF(TIME(16,0,0)<G96,"17",...
¦]¬°¨t²Î±N¤å¦r¦Û°ÊÂà´«¦¨¼ÆȪº°Ê§@¦³¥i¯à¦]¬°¯BÂIºë«×¦Ó²£¥Í»~®t.
¨ä¦¸Æ[¹î§Aµ¹ªº¤½¦¡ :
Q96ªº¦¡¤l ±q 18.5 ª½±µ¸õ 17, 13.5 ª½±µ¸õ 12 ½T¹ê¬O§A·Qnªºµ²ªG¶Ü?
ÁÙ¬O¥´¿ù¤F?
Y¬Oµ¥¶Zpºâ¥i¥H¥Î =IF(G96<TIME(8,30,0),0,HOUR(G96)+IF(MINUTE(G96)<30,0.5,1)) ¨Ó§¹¦¨.
Y¸Ó¦¡µL»~«h¥i§ï¥Î:
=IF(OR(G96>=TIME(18,30,0),G96<TIME(16,30,0)),HOUR(G96)+IF(MINUTE(G96)<30,0.5,1),IF(G96>=TIME(17,20,0),17,16.5))
¸Õ¸Õ¬Ý. |
|