- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 17
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2013-3-1
- ³Ì«áµn¿ý
- 2014-1-6
|
=IF(AND(TIMEVALUE(TEXT(A2,"hh:mm"))<TIMEVALUE("12:00:00"),TIMEVALUE(TEXT(B2,"hh:mm"))>=TIMEVALUE("12:55:00")),(B2-A2)*24-(55/60),((B2-A2)*24)
¬Ý¦æ¤£¦æ~ |
|