2020-01-31 時間の範囲判定 Excel 時と分を数字にして比較 =IFS( AND(1455 <= HOUR(NOW())*100+MINUTE(NOW()),HOUR(NOW())*100+MINUTE(NOW()) <= 1459) ,"GO","") ネタ元 https://dekiru.net/article/4394/