time formula

[rslc]

hi
i have been trying to insert current time in a cell in excel 2007 only
when another cell has been filled but am having trouble with the formula,
here is what i have so far =IF(B6<>"","= time"," ") this just
displays = Time in the cell instead of the time. any help greatly
appreciated

cheers
rslc

 

[Jla]

Try using =Now() instead of time

 

[Gary Keramidas]

this will do what you want, but the time will change with every calc

=IF(B6<>"",TEXT(NOW(),"hh:mm"),"")

 

[Pecoflyer]

There is probably another way but =now()-today() will give you th
current time ( don't forget to format as hh:mm:ss)
This is a volatile formula so it will recalculate each time the shee
is accessed or change

 

[rslc]

Thanks for the reply Gary unfortunetly the time changing is what i'm trying
to avoid, i can use = time to enter current time and not have it
change but have not been able to get it to work in my formula.

cheers
rslc

 

[rslc]

HI Gary
thanks for the reply, but unfortunetly thats what i was
trying to avoid. I can use = time which will give me the result i want
but haven't been able to get it to work in my formula

cheers

rslc