+ Reply to Thread
Results 1 to 5 of 5

If time falls in a certain range

  1. #1
    Registered User
    Join Date
    01-19-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    If time falls in a certain range

    Hello,
    I have a sheet that we use 24 hours a day between 2 people on two shifts. At the beginning of our job we enter our initials as such Setup(A1) = Day worker and Setup(A2) = Night worker

    During the shift when we enter info into a row..our initials need to be at the end of the row.

    What I would like is that if the time is between 6am and 6pm, (time is in Surveys(column D)), I would like the initials of Day Worker to appear in Surveys(column S) and if between 6pm and 6am the initials of Night Worker. And if time column is blank for the column S to be blank of course.

    Any suggestions?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,870

    Re: If time falls in a certain range

    In column S type: =IF(OR(D1>=0.75,D1<=0.25),"FirstInitials","SecondInitials")
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-19-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: If time falls in a certain range

    This sort of help....however...if lets say D3 is blank then it fills column S with "first initials" How do I make it so it stays blank if there is nothing in D?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,870

    Re: If time falls in a certain range

    try this: =IF(D1="","",if(OR(D1>=0.75,D1<=0.25),"FirstInitials","SecondInitials"))

  5. #5
    Registered User
    Join Date
    01-19-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: If time falls in a certain range

    That did the trick..Thanks!

+ 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