1

I am running a study for my thesis, and would very much like to track the time it takes to complete a Google form to compare against how long it takes to fill.

  • Welcome. Please add a brief description of your search/research efforts as is suggested on How to Ask. Also add more details about what kind of solution you are looking for, otherwise the question is primarily opinion-based or too broad. – Rubén May 17 at 23:55
0

A sneaky way would be to ask the respondent to enter a current time as the first question of your form and the actual submission time will act as the end time. Then you just run a simple ARRAYFORMULA in your spreadsheet to get the duration:

=ARRAYFORMULA(IF(LEN(A20:A), A20:A-B20:B, ))

0

  • Is there any system that would automatically capture the start time do you know? – FJLyons May 19 at 23:36
  • unfortunately no. this would be only workaround – user0 May 19 at 23:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.