Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying time from 00:00 to 0.00 | New Users to Excel | |||
Displaying Unix time as date and time | Excel Discussion (Misc queries) | |||
Time displaying wrongly | Excel Discussion (Misc queries) | |||
how do i display a time value conditionally | Excel Discussion (Misc queries) | |||
displaying several charts, one at the time | Charts and Charting in Excel |