If anyone can answer this question .. YAY.
I have two columns within a spreadsheet. I want a date & time value in each column depending on when the field was entered.
My problem is using NOW() .. this updates to the current time and date for all fields within the column.
Is there anyway to add a date & time within a field and lock the values once they are entered?
Ultimately, I would like to calculate the exact time between the two fields.