Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proctecting =NOW() cell from auto update
The only way to have the cell not update is to use a formula using
intentional circular references. To do this, you have to allow circular references at the application level. Tools=Options=Calculate click the iterations box and set Max iterations to 1 then in C1 =IF(LEN(TRIM(A1))0,IF(C1="",NOW(),C1),"") in E1 =IF(LEN(TRIM(D1))0,IF(E1="",NOW(),E1),"") Clearing A1 (D1) will remove the time and the cell will appear empty. An alternate approach would be to use the Worksheet_Change event if entries are made manually. -- Regards, Tom Ogilvy Tom Rector wrote in message om... Win2k office xp pro I have a spreadsheet with two columns, column C "In" and column E "Out", formula in both is Column C =if(A1" ",NOW()," ") and Column E =if(D1" ",NOW()," "). Formated cells as TIME 13:30, This so that if A1 is populated, the current time will show up in C1 and for the second if D1 is populated the current time will show up in E1. Cell F1 has formula =(E1-C1)*24 to give elapsed time in decimal format. Column F is formated as General My problem is that cells C1 and E1 continualy update with current system time. I want to have the cell (time) locked when A1 and D1 are populated. At variuos times, I will need user to clear the lock and start time again. this should be accomnplished simply by 'blanking A1 and D1' and adding new data to A1 and D1) This purpose is to record time used when renting a work stall in a hobby shop. Agian, I really appreciate the help/answers this group always seems to come up with ! Thanks Again, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell =Now() << Can I get this to auto-update? | Excel Worksheet Functions | |||
Auto update a linked Cell | Links and Linking in Excel | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
Proctecting certain cells | Excel Worksheet Functions | |||
Auto update of cell information | Excel Discussion (Misc queries) |