if formula to stop now() code

[lpratt]

is there a way that if i have in ..

A1 - NOW()
B1 - either open or closed

if B1 is closed then the time in A1 will stop or become static.

[davesexcel]

Open or closed what?

[lpratt]

just the text written there

[davesexcel]

So if A1=Now() then B1=Closed or B1=Open?
=if(a1=now(),"Closed","open")
Placed in B1

[lpratt]

hmm not quite

i will attach a copy of what i am doing.. IF TIME STOP DOC.

[royUK]

Maybe

=IF(B1="Open",NOW(),"")

[davesexcel]

This requires VBA.
Try this

Please Login or Register  to view this content.

And goes into the worksheet module
Where the modules are

[royUK]

Possibly


=IF(B1="Open",NOW(),TEXT(NOW(),"dd-mmm-yy, hh:ss"))