4 Replies Latest reply on Aug 2, 2016 5:52 AM by Cheryl Morgan

    Timeframes not Showing

    Cheryl Morgan

      Good morning,

       

      I have a worksheet where I need to display the data within certain time frames. However, only certain timeframes are showing. I cannot figure this out and a coworker was unable to figure it out either. Could someone please look? The timeframes in red are the ones that will not show.

       

      Thank you in advance for your help,

       

      Cheryl

       

      IF  [Collect Time] >= '00:00:00' AND [Collect Time]<='02:59:00' THEN '0000-0259'

      ELSEIF [Collect Time] >='03:00:00' AND [Collect Time]<= '05:59:00' THEN '0300-0559'

      ELSEIF [Collect Time] >='06:00:00' AND [Collect Time] <= '08:59:00' THEN '0600-0859'

      ELSEIF [Collect Time] >= '09:00:00' AND [Collect Time]<= '11:59:00' THEN '0900-1159'

      ELSEIF [Collect Time] >='12:00:00' AND [Collect Time]<= '14:59:00' THEN '1200-1459'

      ELSEIF [Collect Time] >= '15:00:00' AND [Collect Time]<= '17:59:00' THEN '1500-1759'

      ELSEIF [Collect Time] >= '18:00:00' AND [Collect Time]<= '20:59:00' THEN '1800-2159'

      ELSEIF [Collect Time] >= '21:00:00' AND [Collect Time]<= '23:59:00' THEN '2200-2359'

      END