Results 1 to 2 of 2

Thread: "If" and time

  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Unanswered: "If" and time

    I have a coloum of times and I need to show which times are after 6:00 pm.
    I have tried numerous combination and I am getting close with

    =IF(I3>"18:00:00""<24:00:00","Evening","Day")

    but my result is alway "Day"
    Thanking you in advice.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, and welcome to the board.

    Is cell I3 in time, or is actually day and time (how it is normally entered into a cell). You may have to convert to serial numbers; hours would be fractions, and then use that as the basis for determining, and you would have to subtract the serial day to determine what part of the day it is.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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