Determine if time is within a windoww

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
 
T

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

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

Claus Busch

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(C1>A1,C1<B1),"in","out")


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top