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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks