I have cells A1 & B1. What I want is when I put "1" into A1, for B1 to
show the current time. Can I use an IF formula? =IF(A1 =
1,"????","")

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539501

=IF(A1=1,NOW(),"")

Format as Time

--
Kind regards,

Niek Otten

"fastballfreddy" wrote in message
news:fastballfreddy.27dn3m_1146903901.218@excelfor um-nospam.com...
|
| I have cells A1 & B1. What I want is when I put "1" into A1, for B1 to
| show the current time. Can I use an IF formula? =IF(A1 =
| 1,"????","")
|
| Thanks,
|
|
| --
| fastballfreddy
| ------------------------------------------------------------------------
| fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
| View this thread: http://www.excelforum.com/showthread...hreadid=539501
|

Thanks for the reply Niek. I tried that before and it's not working for
what I want it to do.

What I am trying to do is I have a list of 100 #s in column A. Once I
get done working the first # (in A1). I want to put "1" in B1. Once
"1" is entered I want C1 to show the current time. I'll repeat the
steps, finish A2, put "1" in B2 and the current time will show in C3.


With the previous formula: =IF(A1=1,NOW(),"")

C1, C2, C3 and so on would be the same time, updating everytime you
input a "1" if the time change. Is there something that can be changed
w/ the current formula, or is there another formula out there?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539501

I think a macro is needed he-

Right click on the sheet you are using
select View Code
in the first dropdown box towards the top of the page select Worksheet
in the one to the right select selection change
then ensure the code window below displays the following code(copy and
paste the bits you need)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Value = 1 And ActiveCell.Column = 2 And
IsEmpty(ActiveCell.Offset(0, 1)) Then
ActiveCell.Offset(0, 1) = Now()
End If
End Sub

somethinglikeant


--
SLAnt
------------------------------------------------------------------------
SLAnt's Profile: http://www.excelforum.com/member.php...o&userid=34184
View this thread: http://www.excelforum.com/showthread...hreadid=539501