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

[¤À¨É] ­pºâ¸ó¤é¸g¹L®É¶¡

[¤À¨É] ­pºâ¸ó¤é¸g¹L®É¶¡

¦]¦³»Ý­n­pºâ­pºâ¸ó¤é¸g¹Lªº®É¶¡, §Æ±æ¥iÀ°§U¤j®a(¦p¹Ï)

­pºâ¸ó¤é®É¶¡.jpg (19.82 KB)

­pºâ¸ó¤é®É¶¡.jpg

ÁÙ¦³¤@ºØ ¬O ¥­±`¿é¤J¥i¥H§ó§ï¹L
¦V§Ú­Ì¤½¥q ¸ê®Æ®w
®É¶¡¬O
20150327074100 ¦~¤ë¤é®É¤À¬í
«áÄò¦A¥Î mid ¨ú¥X¦Û¤v­nªº ¤]«Ü¤è«K

TOP

*24¬O¿ù»~ªºÆ[©À

EXCELªº®É¶¡¤@¤Ñ¬O 1
©Ò¥HÀ³¸Ó¬O *1

¬°¦óÅã¥Üµª®×¬O¹ïªº? ¤j®a¥i¥H·Q¤@·Q
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089

³o¸Ì§Æ±æ¤é´Á¬Û´î«á¥H¤p®É¬°³æ¦ì
http://forum.twbts.com/redirect. ... 5830&ptid=13569
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 1# xmi
¦^´_ 4# GBKEE

¨Ì¼Ó¥Dªº¤½¦¡­pºâ¦p¤U
A2 = 03:00
B2 = 01:30
C2 = B2 - A2 + (A2 > B2)*24

= 01:30 - 03:00 + (03:00 > 01:30) * 24
= -01:30 + (TRUE) * 24
= 23¤é + 22:30

ª`·N¡A­pºâ«á¬°23.9375¡A23¬°23¤é³o¬O¦hªº¡A0.9375¬°®É¶¡22:30
¦]¬°Àx¦s®æ®æ¦¡¥uÅã¥Ü®É¶¡¨S¦³Åã¥Ü¤é¡A©Ò¥Hµª®×¦ü¥G¬O¹ï?¨ä¹ê¬O¿ù»~ªº¡C

¤½¦¡»Ý­×§ï¬°
C2 = B2 - A2 + (A2 > B2)
©Î
C2 = MOD(B2-A2,1)


­Y­nÂର¤p®É¤½¦¡¬°
C2 = (B2 - A2 + (A2 > B2)) * 24
  ©Î
C2 = MOD(B2-A2,1)*24
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^ÂÐXMI
=$B2-$A2+IF($A2>$B2,1)¡A±o¨ìªº­È·|¸ò§A¤@¼Ë(¶W¹L24¤p®É·|¨S°ÝÃD)¡A¦pªG¥Î*24¤p®É¥h´«ºâ·|¦³¤@¨Ç°ÝÃD¡Aµ¹§A°Ñ¦Ò

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD