Determine if time is within a windoww
 

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

Determine if time is within a windoww
 

On Tuesday, January 20, 2015 at 5:59:10 PM UTC-5, travis wrote:
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

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

Determine if time is within a windoww
 

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...

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


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional