Lookup if Time Between

Hi,
please try this in J3 and down:
=IF(SUM(((Table27[@area]=Table16[area])*(VALUE(Table27[@time])>=VALUE(Table16[min]))*(VALUE(Table27[@time])<=VALUE(Table16[max])))),1,3)