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


"Gary Keramidas" wrote in message
...
this will do what you want, but the time will change with every calc

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

--

Gary
Excel 2003


"rslc" wrote in message ...
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