Displaying the current system time - 2nd Try

[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!

Currently I have this formula in cell I4: "=IF(L4="Y",HOUR(now),0)". With
no entry input in L4, I4 displays "12:00 AM". When I enter a "Y" in L4, it
displays #NAME?.

Does anyone have any suggestions for the proper formula?

 

[Guest]

=if(L4="Y",NOW(),"0")

 

[Dave Thomas]

You're missing the parenthesis in the now function, your formula should be
=IF(L4="Y",HOUR(NOW()),0)

 

[Dave Thomas]

All functions need parentheses, even if there is nothing in the parentheses
as in the case of NOW()