+ Reply to Thread
Results 1 to 2 of 2

time:DAYS or NIGHTS

  1. #1
    Registered User
    Join Date
    02-22-2007
    Posts
    21

    time:DAYS or NIGHTS

    I have a cell (A1) displaying the current time eg. 02:02:08. I would like to use that data in another cell (B1) and display either DAYS or NIGHTS depending on the current time. 0700-1900 would be DAYS, 1900-0700 would be NIGHTS.

    Any help?

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    In B1:

    =IF(AND(HOUR(A1)>=7,HOUR(A1)<19),"DAYS","NIGHTS")

    Jason

+ Reply to Thread

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