I am new to Google Sheet, I have just started to use recently. So I am not familiar with.
In Google Sheet, I want to record my timing for every actions while I start and end an action.
For example, if I have three columns, A1 = Start time; A2 = End time; A3 = Time taken (A2-A1, this we can use it in formula)
But I want to make the time recording by automatically, e.g., Before I start my action, I wish to click on A1, the cell will automatically shows the current time and it should not change afterwards. Then, after I completed my work, I wish to click on A2 to record end time that means to record end time of my action to calculate actual time taken for my action.
Is it possible to get the current time by clicking the cell and it should not change afterwards?
Best Answer
Format A3 as Duration with formula:
Then when you start select A1 and Ctrl+Shift+: and when you finish select A2 and Ctrl+Shift+:.