Formula runs based on time

Hi Ben_Hensel,

Thanks for the help, It really did the trick.

But i think it should be "less than" because if we are to use "greater than, The log in time would not appear.

as for the "WO", I just used this formula IF(C6="WO","WO",IF(C6<=(NOW()-TODAY()),VLOOKUP(B6,raw!A:D,4,0),""))



Thanks for the help!!!

Just a follow up question:

What if I were to change the timezone in "time and date" settings of the computer.
Is there a way to always stick with Pacific time format?