+ Reply to Thread
Results 1 to 2 of 2

Cell Value Based On Time In Another Cell

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010, 2016, 2021-22
    Posts
    87

    Cell Value Based On Time In Another Cell

    I'm trying to label entries off a time stamp that will determine "1st Shift" or "2nd Shift".

    The time stamp is entered into column G whenever data from column E is changed. I would like column H to identify whether it's 1st shift or 2nd shift.

    I found the below code but I don't know how to put it in practice

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Cell Value Based On Time In Another Cell

    Hi, I suggest you attach the worksheet with the data as sample. Howeven the Time value is constantly changing so you do not use this to compare if you open your file at 10 AM it will be different than if you open the file at 4 PM
    My first thought is that instead of TimeValue you use TimeSerial which is a numeric entry
    Second, the comparisson with greater than or equeal to.
    The Overtime part is not an AND but an OR question.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy data from one cell to another specified cell based on current time
    By Daisy_Mu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2021, 03:27 PM
  2. Update the cell value and time based on the Reference cell
    By Prabukaliappan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2020, 01:07 AM
  3. Update the cell value and time based on the Reference cell
    By Prabukaliappan in forum Excel General
    Replies: 1
    Last Post: 04-08-2020, 01:07 AM
  4. Replies: 1
    Last Post: 02-19-2020, 11:57 AM
  5. having a difficult time coding a cell value change based on another cell row
    By pokemon53 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2015, 07:32 AM
  6. returning time in one cell based on number in another cell
    By megamef in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2014, 08:18 AM
  7. Replies: 3
    Last Post: 05-28-2013, 10:43 AM

Tags for this Thread

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