Display Value if Time Between X & Y [Semi-Urgent]

  • Thread starter Thread starter tcrass
  • Start date Start date
T

tcrass

I am having one heck of a time figuring out a forumla to handl
displaying conditional data dealing with time. Here's what I want t
do...any ideas on how I can do it easily?

Cell B5: 9:00 (Start Time)
Cell B6: 17:00 (End Time)

Column A
Cell A1: 10:00 (Time)

IF A1 is equal to or greater than B5 and less than or equal to B
display 1, otherwise display 0

Example Desired Format:


Code
 
One way

=((A1>=B5)*(A1<=B6)*(A1<>""))

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Thanks for the 2 suggestions, however, these don't address m
problem...

I'm not looking to add or multiply the values as your formulae woul
suggest, I am looking to simply "display" a value if a cell equal
another value. The forumla I have started with is as follows:

=IF(B5<=A1<=B6,1,0)

This however, is not working correctly...

Any guidance as to what I'm doing wrong in this formula would b
helpful... Thanks again
 
Hi
just try these formulas. They'll work :-)
They're a shorter form of
=IF(AND(A1>=B5,A1<=B6),1,0)
can be shortened to
=(A1>=B5)*(A1<=B6)
 
Back
Top