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?

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



"Zach" wrote:

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?

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

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

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?

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

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

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?