Results 1 to 3 of 3

Selecting items by time range

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2017
    Location
    Zimbabwe
    MS-Off Ver
    2013
    Posts
    28

    Selecting items by time range

    Hi all

    I would like to select some items by time range. In the attached spreadsheet, I want column B to indicate with a 1 (one) if the time is in the range 6 AM to 6 PM inclusive and a 0 (zero) if the time is outside this range. I tried the formula indicated in column B, but it gives zeros throughout and I am not sure what’s wrong with this formula. Can someone provide the correct formula or an alternative way of doing this.

    Regards

    JJ
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Selecting items by time range
    By jmasanganise in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2018, 09:02 AM
  2. Data Validation - Selecting multiple items with ability to deselect items
    By dsklein85 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-12-2016, 09:02 AM
  3. [SOLVED] Receive a Run-time error '1004' when selecting a designated range of rows
    By blrunning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2015, 08:52 AM
  4. Run-time error 1004 selecting range
    By Ray Sofio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2014, 04:55 PM
  5. [SOLVED] Run time error when range for list box has less than two items.
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-08-2014, 04:45 PM
  6. Run Time Error 1004 when selecting range on another sheet using a command button
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 07:43 AM
  7. selecting multiple listbox items based on test in range
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2009, 04:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1