IF formula for time

F

fastballfreddy

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,
 
N

Niek Otten

F

fastballfreddy

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,
 
S

SLAnt

I think a macro is needed here:-

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 an
paste the bits you need)

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

somethinglikean
 
Top