時と分を数字にして比較 =IFS( AND(1455 <= HOUR(NOW())*100+MINUTE(NOW()),HOUR(NOW())*100+MINUTE(NOW()) <= 1459) ,"GO","") ネタ元 https://dekiru.net/article/4394/

数値を文字列に変換 =TEXT(B3,"@")文字列の数字を数値に変換 =VALUE(B3) ネタ元 http://www4.synapse.ne.jp/yone/excel/excel_data_katahenkan.html#mojiretu