I have a spreadsheet consisting of one column and ten rows. The spreadsheet also has a cell containing a timer in the format hh:mm:ss.
The values in the single column are updated 'live' over a 30 minute period.
My problem is I would like to automatically 'Lock/Freeze' the values in the column at a certain time (e.g after 10 minutes ) during the 30 minute period they are being updated.
I would appreciate any help on how to do this