View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Travis Travis is offline
external usenet poster
 
Posts: 2
Default 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