Displaying a time value, conditionally.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying the current system time - 2nd Try 3
Help needed 0
Excel conditional formatting with Weeknum 4
Returning a value if multiple conditions are met 2
Condition Format with value of other column 2
Excel VBA 1
want to track time while paste value in multiple column of same roe 1
OFFSET with a condition 0

Back
Top