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
|