VBA Code based on NOW (time)

[poikl]

Hi,
I have the following code in MACRO in ColM to enter initials based on the NOW entry in ColA. However it always enters FM no matter what time so it's not working!
In ColM I have entered "Cells(c.Row, "m").Formula = "=IF(RC[-12]<=TIMEVALUE(""3:50:00 PM""),""RB"",""FM"")"
In ColA I have:"Cells(c.Row, "A").Value = Format(Date, "m/d/yy") & " " & Format(Time, "hh:mm:ss")
Can you please help correct the code so that an entry after 3:50PM shows "FM" and anything earlier (of same date) shows "RB"?

 

[poikl]

Sorry,No, I wasn’t aware of that. I was under the impression that the date and time was already picked up in the adjacent row ColA from the code “"Cells(c.Row, "A").Value = Format(Date, "m/d/yy") & " " & Format(Time, "hh:mm:ss")”.
(BTW, the running log sheet I’m using is already at row 2169. I don’t know if that makes a difference but figured just to throw that out just in case).
Can’t thank you enough Mark for all your efforts on this project

 

[MARK858]

Sorry,No, I wasn’t aware of that

It's been there since post 9

(BTW, the running log sheet I’m using is already at row 2169. I don’t know if that makes a difference but figured just to throw that out just in case).

Definitely makes a difference that the

=TODAY()

needs to be in a separate cell and not in the formula

Sorry,No, I wasn’t aware of that. I was under the impression that the date and time was already picked up in the adjacent row ColA from the code “"Cells(c.Row, "A").Value = Format(Date, "m/d/yy") & " " & Format(Time, "hh:mm:ss")”.

You haven't stated anywhere in the post what code (if any) you are using for cells other than the partial code for column M so I wouldn't be aware that you had it.

That line can be written as just

Cells(c.Row, "A").Value = Format(Now, "m/d/yy hh:mm:ss")

btw

Whether you can reference the column A value rather than using =TODAY() only you will know, as only you know how your worksheet works and what you are trying to compare.

 

[poikl]

Mark, Thank you, thank you, thank you. I entered all the information per your instructions and it works exactly as was needed. Have a wonderful day

 

[MARK858]

You're welcome