Mark, Roger,

Thanks for the prompt response, worked a treat.

Regards

Pank

"Roger Govier" wrote:

Hi

Your logic is perhaps incorrect, unless you are dealing with differing days.
If you are checking whether the time is between 7:30 and 15:30 on the same
day then try the following.

=IF(AND(H6=TIME(7,30,0),H6<=TIME(15,30,0)),41078, 41079)

Your time in H6 would need to be entered in 24 hr format though, 13:30 and
not 1:30 which would give the false result.

Regards

Roger Govier


Pank wrote:
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