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

«Y¤½¦¡«×¼g®É¶¡

«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)

¹ï¤£°_, ¥»¤H¥H¬°­ÓEXCEL UPLOAD­ø¨ì, ©Ò¥H±øFORMULA·|¦³ÂI¤£¦P,
­Y¯àDL ­ÓEXCEL, ±øFORMULA«Y= SHEET 2 I14

ÁÂÁÂ

TOP

I14=IF(G14="","",H14-G14-1/24*(D14<>"Sat")*(HOUR(G14)<HOUR("13:00"))*(HOUR(H14)>HOUR("14:00")))

TOP

±o¥ª³â!!ÁÂÁ§r^^

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD