How do I call current computer time to a cell?

  • Thread starter Thread starter Carol G.
  • Start date Start date
C

Carol G.

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
 
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-
 
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
 
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.
 
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).
 
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.
 
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.
 
Back
Top