Excel式でザラ場中の時間だけ表示

=IF(TIMEVALUE(TEXT(NOW(),"hh:mm"))<=TIMEVALUE("9:00"),"--:--(前場前)",IF(TIMEVALUE("15:00")<TIMEVALUE(TEXT(NOW(),"hh:mm")),"15:00",TIMEVALUE(TEXT(NOW(),"hh:mm"))))