Use the formula:

=IF(LEN(A1)0,NOW(),"")

it should work...

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Carol G." wrote:

Thank you for your reply. The formula works but how can I get it to not fill
in the
time until the date is filled in, otherwise, what activates or calls the
formula? This is for a spreadsheet that requires a list of dates, times and
balances.
Thank you.

"Ashish Mathur" wrote:

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