title: Formula to Assign whether a date is "In Business Hours" or "Outside Business Hours" in excel
body: <p>I'm trying to create a formula to determine whether a phone call was made inside or outside of business hours based on the day and time of the call</p>
  
  <p>Business hours are Monday to Friday 8AM to 8PM and Saturday 8AM to 2PM.</p>
  
  <p>So essentially what I need to create the formula for is;</p>
  
  <p>if call is Monday, Tuesday, Wednesday, Thursday, Friday and time is >8 and &lt;20 or call is Saturday and time is >8 and &lt;14 then show "Inside Business Hours"</p>
  
  <p>For everything else show "Outside Business Hours"</p>
  
  <p>Thanks</p>