Inserting time into cell in excel and have it not change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
There already is one
ctrl + semi colon produces the date
ctrl + Shift + semicolon (ctrl+Colon) produces the time
 
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?
 
Back
Top