Displaying a time value, conditionally.
 

I've been trying to display the current "time out" in one cell if another
cell contains a "Y" for work finished. I used the IF function to tried and
set up conditions, but always receive errors. If a "Y" is entered the last
column of the sheet for that row, then I need the display the current system
time on that computer. If no "Y" is entered in the last column, I need the
cell to remain blank. I've looke don the Microsoft site for example and
tried the help function in Excell. No luck!

Does anyone have any suggestions for the proper formula?

Displaying a time value, conditionally.
 

=IF(A2="Y",NOW(),"")

problem is that the value updates every time the sheet recalculates.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Zach" wrote in message
...
I've been trying to display the current "time out" in one cell if another
cell contains a "Y" for work finished. I used the IF function to tried
and
set up conditions, but always receive errors. If a "Y" is entered the
last
column of the sheet for that row, then I need the display the current
system
time on that computer. If no "Y" is entered in the last column, I need
the
cell to remain blank. I've looke don the Microsoft site for example and
tried the help function in Excell. No luck!

Does anyone have any suggestions for the proper formula?