=if(b1="","",now())

Format A1 to include both the time and date:

hh:mm:ss mm/dd/yyyy

Brian wrote:

Hello,

Can someone help me with this one?

in Cell A1 I would like to have the current Time and date ( in that order)
returned if Cell B1 contains any data text or numbers in it. Otherwise I
would like Cell A1 to be blank if B1 is blank.

Thank You
Brian

--

Dave Peterson