Determine if time is within a windoww

  • Thread starter Thread starter Travis
  • Start date Start date
T

Travis

need a formula to determine if en event time is within a given window. Cell1 has window start time. Cell 2 has window end time. Cell 3 has event time.. Want cell 4 to read "in" or "out" dependent on the event time being inside or outside of the specified window...

any help would be great!

Thanks
Travis
 
need a formula to determine if en event time is within a given window. Cell 1 has window start time. Cell 2 has window end time. Cell 3 has event time. Want cell 4 to read "in" or "out" dependent on the event time being inside or outside of the specified window...

any help would be great!

Thanks
Travis
Click to expand...

Also, cell time format is 1/9/2015 11:59:00 PM
 
Hi,

Am Tue, 20 Jan 2015 14:59:07 -0800 (PST) schrieb Travis:
need a formula to determine if en event time is within a given window. Cell 1 has window start time. Cell 2 has window end time. Cell 3 has event time. Want cell 4 to read "in" or "out" dependent on the event time being inside or outside of the specified window...
Click to expand...

try:
=IF(AND(C1>A1,C1<B1),"in","out")


Regards
Claus B.
 
Back
Top