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

[µo°Ý] ®É¶¡°ÝÃD½Ð±Ð

[µo°Ý] ®É¶¡°ÝÃD½Ð±Ð

DEAR  ALL¤j¤j
1.RANGE("A1")=18112619   ¼Æ¦r®æ¦¡¤º®e
1.1  18ªí¥Ü2018¦~¡A1126ªí¥Ü11/26¡A19ªí¥Ü19:00
2.RANGE("B1")=2018/11/26 21:00 ¤é´Á®æ¦¡¤º®e
3.½Ð±ÐRANGE("C1")­n­pºâ RANGE("B1")»P RANGE("A1")¬Û®t¤§¤p®É¼Æ.
3.1 ¦¹½d¨Òµ²ªG=2¤p®É
4.²[¼Æ¸Ó¦p¦ó®Ñ¼g.·Ð¤£§[½ç±Ð   THANKS*10000
ù

=(B1-TEXT(A1,"0-00-00 00!:!0!0"))*24

TOP

DEAR ­ã´£³¡ªL ¤j¤j
100%²Å¦X»Ý¨D  THANKS*10000
ù

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD