CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT

[Thomasel]

I want to enter someones name in one cell and have the current time post in
another cell.

 

[Gary''s Student]

In A1 type the name and in B1 touch:
CNTRL-SHFT-;

 

[Donna]

Hi Thomasel,

Try this:

In the cell where you want the time, type =IF(C9<>"";now();"")

(where C9 is the cell where you want to type the name)

In the resulting cell, you will have to format the cell to the hour format
you want as this will give both the date and time. Also, this hour will
change as it is the current (updating) date/time. If you want it to remain
static, copy the cell and do a Paste Special with Values.

Hope this helps, have a great day!

 

[Donna]

OOops,

In the reponse I just sent, I used semi-colons to separate the fonction's
arguments. I use a French version of Excel. In the English version, you
would use commas to separate the arguments.