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

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

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

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

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

My guess is that you will not want the date or time to change once you have
entered them. Using the NOW and/or TODAY functions will not give you this
permanence. While not automatic, are you aware of the short cut keys to
enter the non-changeable date and time into a cell? To place the date, key
in Ctrl+; (the Control key coupled with the semi-colon key). To place the
time, key in Ctrl+Shift+; (the Control and Shift keys coupled with the
semi-colon key).

--
Rick (MVP - Excel)


"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

Hi Carol,

The NOW() function will update every time your sheet recalcs.
Take a look here for a time stamp that will hold.
http://www.mcgimpsey.com/excel/timestamp.html

HTH
Martin




"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

When I drag this formula down the page, it enters the time in every cell, even
those without a date in column A. This is the idea that I want (check for
entry in
Column A) but it doesn't work....yet. Any other ideas?

Thanks.

"Shane Devenshire" wrote:

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

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

Thank you so much Rick. This is just what I needed. You guessed correctly
that I did not want the time to recalculate as this is a list of balances at a
particular date and time. You nailed it even though I couldn't explain it!
Thanks.

"Rick Rothstein" wrote:

My guess is that you will not want the date or time to change once you have
entered them. Using the NOW and/or TODAY functions will not give you this
permanence. While not automatic, are you aware of the short cut keys to
enter the non-changeable date and time into a cell? To place the date, key
in Ctrl+; (the Control key coupled with the semi-colon key). To place the
time, key in Ctrl+Shift+; (the Control and Shift keys coupled with the
semi-colon key).

--
Rick (MVP - Excel)


"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