time formula
Try using =Now() instead of time
"rslc" wrote:
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
|