How to
How to see times in Google Sheets
Form Timer records when each respondent started, when they finished, and their total duration, then writes it next to their answers in the spreadsheet linked to your form.
-
Link your form to a spreadsheet
In the Forms editor, open the Responses tab and click the Sheets icon to create a new spreadsheet or select an existing one. Timing columns can only appear if the form has a linked Sheet, so do this before collecting responses.
-
Collect timed responses
Share the form and let responses come in. Submit one test response yourself first so you can verify the columns without waiting for the real audience.
-
Open the Sheet and read the timing columns
Next to the regular answer columns you will find the Form Timer fields: the respondent status with time taken, and when they started. A respondent who finished within the limit shows their completion time; one who ran past it shows the overrun; one who never submitted is marked as not submitted.
-
Sort and analyze
Sort by duration to surface outliers: a suspiciously fast finish on a long exam, or respondents who needed far more time than planned. The columns are ordinary Sheets data, so filters, pivots, and charts all work.