- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- 2000
- ³nÅ骩¥»
- Office 2000
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-5-19
- ³Ì«áµn¿ý
- 2011-5-19
|
«Y¤½¦¡«×¼g®É¶¡
¤j®a¦n
¥»¤H³ÌªñÀ°¤½¥q¾ã¤@±i¤u®Éexcel, ¦ý¼g¤½¦¡®É«o¹J¤W¤@Ó°ÝÃD´N¬O»{¤£¨ì¨º¬O®É¶¡
¦p:
A1¬O¤W¯Z®É¶¡ E.G. 09:00
B1¬O¤U¯Z®É¶¡ E.G. 17:30
C1¬O¤@¤Ñªº¤u®É E.G. 07:30 (¥Ñ©ó§Ú̬O¤£p¦~¶º®É¶¡)
¥Ñ©ó¥»¤½¥q¶·©ó¬P´Á¤»ªð¥b¤é9-1¡A§Ú¬O¦¨¥\SET¨ì±ø¤½¦¡¸ÜY¬O¬P´Á¤»«K¤£¥Î´î¤@¤p®ÉLUNCH®É¶¡
=IF(D1="Sat",(B1-A1),B1-A1-60/24/60)
¥i¬O, Y§Ú¥¤éªºªð¤u®É¶¡¤£¾î¸Ø¤È¶º®É¶¡«h³£·|´î¤@¤p®É, §Ú·Q¾ã¨ì«Y¦p¤W¯Z®É¶¡¬O14:00¤§«á, ¦Ó¤U¯Z®É¶¡¬O13:00¤§«e, ¨º»ò«K¤£¥Î´î¤@¤p®É¥i¥Hªº¶Ü?
·Ð½Ð¦U¦ìÀ°¦£¸Ñµª, ÁÂÁÂ~ |
-
-
111.zip
(7.19 KB)
-
-
111.zip
(7.19 KB)
|