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
|