Inserting time into cell in excel and have it not change
 

I'm creating a time management spreadsheet that uses column A row 1 (start
time) and column B row 1 (end time) to calculate the total time by
subtracting the two.
The problem I'm having is that when I go to row 2 and start over, and use
the following formula for A2 =NOW() then A1 and B1 (which also use that
function) change as well.

I'd like to make a hotkey to insert the current time into a cell and leave
it there as static text not some updatable function. Any ideas?

Inserting time into cell in excel and have it not change
 

There already is one
ctrl + semi colon produces the date
ctrl + Shift + semicolon (ctrl+Colon) produces the time

--
Regards,
Tom Ogilvy

"iculus" wrote in message
...
I'm creating a time management spreadsheet that uses column A row 1 (start
time) and column B row 1 (end time) to calculate the total time by
subtracting the two.
The problem I'm having is that when I go to row 2 and start over, and use
the following formula for A2 =NOW() then A1 and B1 (which also use that
function) change as well.

I'd like to make a hotkey to insert the current time into a cell and leave
it there as static text not some updatable function. Any ideas?

Inserting time into cell in excel and have it not change
 

Try

CTRL-SHIFT-;

In article ,
iculus wrote:

I'm creating a time management spreadsheet that uses column A row 1 (start
time) and column B row 1 (end time) to calculate the total time by
subtracting the two.
The problem I'm having is that when I go to row 2 and start over, and use
the following formula for A2 =NOW() then A1 and B1 (which also use that
function) change as well.

I'd like to make a hotkey to insert the current time into a cell and leave
it there as static text not some updatable function. Any ideas?

Inserting time into cell in excel and have it not change
 

I am trying to insert date in time in a cell in Excel. I have read what has
been offered and followed the steps but I can't the process to work. Do you
think that you could be 'see spot run' in your instructions?

"JE McGimpsey" wrote:

Try

CTRL-SHIFT-;

In article ,
iculus wrote:

I'm creating a time management spreadsheet that uses column A row 1 (start
time) and column B row 1 (end time) to calculate the total time by
subtracting the two.
The problem I'm having is that when I go to row 2 and start over, and use
the following formula for A2 =NOW() then A1 and B1 (which also use that
function) change as well.

I'd like to make a hotkey to insert the current time into a cell and leave
it there as static text not some updatable function. Any ideas?