Hi Bill,
I appreciate your writing back...
I'm trying to figure out how to incorporate the first case on time flag into this and show the provider's first case...sorry for my lack of understanding.
if(num(Time(PIR_TIME,'hh:mm:ss')) > num(time('6:54:59','hh:mm:ss')) and num(time(PIR_TIME,'hh:mm:ss')) <= num(time('8:35:00','hh:mm:ss')) , 'Y', 'N' ) as TFInWindow, //5 mins grace