- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-3-22 16:17 ½s¿è
¦^´_ 1# ad71631
°²³]±zAÄæ®É¶¡¸ê®Æ¬°¤å¦r®æ¦¡¡A¥B¯S¨Òª¬ªp¤À¥¬©ó12:00:00-13:05:59¤§¶¡¡A«h
1.½Ð©óB1Àx¦s®æ¿é¤J
=IF(AND(TIMEVALUE(A1)>TIMEVALUE("12:00:00"),TIMEVALUE(A1)<TIMEVALUE("13:05:59")),MROUND(TIMEVALUE(A1),TIMEVALUE("00:30:00")),CEILING(TIMEVALUE(A1),TIMEVALUE("00:30:00")))
2.B1Àx¦s®æ«ü©wÀx¦s®æ®æ¦¡_¼ÆÈ_®É¶¡_Ãþ«¬¬°¡u13:30¡v
3.©¹¤U½Æ»s¤½¦¡ |
|