Inserting time into cell in excel and have it not change

[iculus]

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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"iculus" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[JE McGimpsey]

Try

CTRL-SHIFT-;

In article <[email protected]>,
iculus <[email protected]> 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?

[sgraham]

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 <[email protected]>,
> iculus <[email protected]> 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?
>