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

®É¶¡ªº°ÝÃD~

®É¶¡ªº°ÝÃD~

§Ú·Q¦bA1¸Ì·í®É¶¡¦b¨C¤Ñªº¤W¤È10:00:30«e¡AÅý¥¦Åã¥Ü¬°"Y"¡A¨C¤Ñ¹L¤F³o­Ó®É¶¡¤§«áÅã¥Ü¬°"N", ¦³­þ­Ó¤j¤j¥i¥HÀ°À°¦£¶Ü~~

¦^´_ 1# ms2001
A1 Äæ¦ì¤º¿é¤J
=IF(TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) < TIMEVALUE("10:00:30"), "Y", "N")
§Y OK!

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD