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
Bookmarks