Thread: time formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rslc[_2_] rslc[_2_] is offline
external usenet poster
 
Posts: 13
Default time formula

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