| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting time inside cell | New Users to Excel | |||
| Inserting time inside cell | Excel Discussion (Misc queries) | |||
| Checking time and inserting a value in a different cell | Excel Discussion (Misc queries) | |||
| Inserting time in cell to the right | Excel Worksheet Functions | |||
| Inserting time stamp onchange of any cell | Excel Programming | |||
Threaded Mode
