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

®É¶¡¬Û®t

®É¶¡¬Û®t

¦p¦ó¦bBÄ椺ºâ¥XAÄæ®É¶¡ªº¬Û®t......ºâ¥X¨Óªº¬O¹ê»Ú®É¼Æ,
¥t¥~,CÄæ¬O­nºâ¤u§@®É¼Æ,¤]´N¬O¹ê»Ú®É¶¡¦A´î1

®É¶¡¬Û®t.zip (5.77 KB)

joyce

¦^´_ 4# ML089

­ì¨Ó°ê¾ä¤é´Áªº¤å¦r«e­±­n¥[r ¤~¯àÂà´«¬°¼Æ¦r°Ú¡IÁÂÁ±zªº±Ð¾É

TOP

¦^´_ 6# leiru

¬Ý¤£®e©ö²`¨è¤F¸Ñ¡A
°ß¦³³z¹L¦Û¤vºt½m¤@¹M¡A¤~ª¾¹D®t²§(¬Ü¨¤)¦b­þ¸Ì¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ¦U¦ì¤j®v¸Ô²Ó¸ÑÄÀ,¹ï©ó:ª½°}¦C¡B2ºû°}¦C¡B¤ô¥­°}¦C¤§¶¡ªº¹BºâÃö«Y,«Ü­¯¥Í,¥ý°O¤U¨Ó,¦n¦n¬ã¨s¤@µf.....
joyce

TOP

¦^´_ 3# aer

¸É¥R°}¦C¹Bºâªº¤À¸Ñ¨BÆJ¡A¥i¥HÀ°§U§A¤F¸Ñ

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# aer

B2 =SUM(({"r";""}&MID(A2,{1,19;11,29},{9;5}))*{-1,1})*24
³æ¦ì: ¤p®É

SUM¡BMID »¡©ú«öF1´N¦³

¤å¦r«¬¦è¤¸¤é´Á "2014/1/22" ¥i¥Hª½±µ *1 Âà´«¬° ¤é´Á«¬¼Æ­È
¤å¦r«¬°ê¾ä¤é´Á "103/1/22" »Ý­n¦b«e¤è¥[ "r" §ï¬°  "r103/1/22" ¤~¥i¥H *1 Âà´«¬° ¤é´Á«¬¼Æ­È
{"r";""}&...¡Aªí¥Ü²Ä¤@¦C±µ "r"(¤é´Á»Ý­n¥["r")¡B²Ä¤G¦C±µ "" (®É¶¡¤£»Ý­n¥["r")

{"r";""} ¬O««ª½°}¦C
{1,19;11,29},{9;5}¬O2ºû°}¦C
{-1,1}¬O¤ô¥­°}¦C

¥i¯à¤j®a¤ñ¸ûÂण¹L¨Óªº¬O  ««ª½°}¦C¡B2ºû°}¦C¡B¤ô¥­°}¦C¤§¶¡ªº¹BºâÃö«Y¡A³o³¡¥÷¥i¥H¿ï³¡¥÷¤½¦¡«öF9¥h¤F¸Ñ­pºâ¹Lµ{
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
½Ð±Ðª©¥D¥i§_¸ÑÄÀ
B2 =SUM(({"r";""}&MID(A2,{1,19;11,29},{9;5}))*{-1,1})*24
¤½¦¡ªº·N«ä¡H ­n¦p¦ó§ä¨ì¦¹¥Îªkªº»¡©ú¡HÁÂÁ¡I

TOP

B2 =SUM(({"r";""}&MID(A2,{1,19;11,29},{9;5}))*{-1,1})*24
³æ¦ì: ¤p®É

C2 =B2-1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD