Excel Office 2003
I am creating a timesheet. When a person enters their name, the cell next to it has the following formula. The formula just creates a date stamp.
=IF(L7>"",NOW(),"")
However, it's my understanding that the formula is "volatile" meaning, as soon as the next row is entered into the worksheet, it updates to the computer time.
How do I keep the time?
I am creating a timesheet. When a person enters their name, the cell next to it has the following formula. The formula just creates a date stamp.
=IF(L7>"",NOW(),"")
However, it's my understanding that the formula is "volatile" meaning, as soon as the next row is entered into the worksheet, it updates to the computer time.
How do I keep the time?