Hi,

I need to record time next to eg.: W3 cell,
now i'm using below formula :

=IF(W3<>"",NOW(),"")

but the NOW function keep updating time itself,
is there any VBA code or function that I can use with this formula ?