How do I call current computer time to a cell?
Hi,
To address your actual question:
in B1 enter the formula =IF(A1<"",NOW(),"")
Format this as previously described and copy it down as far as you wish.
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Carol G." wrote:
I want to enter today's date in cell A and have the computer
automatically enter the current time (from the computer clock)
into cell B when cell A is filled in. I want the time to be 11:00 PM format.
I am using Excel 2003 version
|