Thread: How do I call current computer time to a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default How do I call current computer time to a cell?
Hi,

You can use the NOW() function in cell B1. Once you have done so, press
Ctrl+1 and in Number Category Custom Type delete the dd-mm-yyyy I.e.
just let hh:mm remain.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Carol G." <Carol wrote in message
...
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

Reply With QuoteReply With Quote