How do I call current computer time to a cell?
the formula is =now()
it returns and ate and time as well.
to show only the time, right click on the cell select "format cells",
in the number tab (first one), in the category ;list , select time and on
the right side, select the way you want to show your time-
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India
"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
|