TIME IN bETWEN HOURS

[game123]

I HAVE TIME FROM DATE FIELD LIKE 15:44, i WANT TO CHECK IF IT FALLS BETWEEN 10 am TO 8 pm OR (10 TO 22 ) tried few things from earlier posts but not working : (

It shoud say 1 if true, 0 if not

any pointers help will be appreciated

 

[63falcondude]

Let's say that your data looks like this:

	A	B	C	D	E
1	15:44	1		10:00	20:00

<tbody>
</tbody>

B1 =--AND(A1>=$D$1,A1<=$E$1)