I have Column H that has been formatted as time (i.e. 1:30 PM).

If the value in column H is Less than 07:30 and Greater than 15:30, I would
like the number 41079 populated in the appropriate cell in column J. If the
test is not False, I would like the value 41078 populated.

I have inserted the following formula in H6 €˜=IF(H615:30 and
<7:30,41078,41079), however when I depress the enter key J6 displays #NAME.

Can you help?

Thanks

Pank