Results 1 to 4 of 4

Unable to display Correct Text with Time reference

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2009
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    98

    Unable to display Correct Text with Time reference

    Column B and C are opening and closing times of an exchange. For instance Product A exchange opens at 2300hrs and closes at 2140hrs the next day (or the exchange remains closed between 2140hrs and 2320hrs everday). Product B opens at 0710hrs and closes at 1620hrs. If the Time Now (Cell H1) is in between the opening and closing hours I would like to display that as "ON" in column D.

    I have tried combinations of AND and if functions along with subtracting times but no joy. Any help would be appreciated. Thansk
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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