title: Using Formula to determine Shift from Time data
body: <p>I have a column of time data formatted like this: <code>hh:mm:ss</code></p>
  
  <p>I want to make an IF statement that returns 1, 2 or 3 corresponding to first, second or third shift if the times fall between certain values.</p>
  
  <pre><code>=IF(AND(E50&gt;8,0,0,E50&lt;16,0,0),"First",(IF(AND(E50&gt;=16,0,0,E50&lt;24,0,0), "Second", "Third")))
  </code></pre>
  
  <p>That's what it looks like now, but it doesn't work.</p>