2

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 '19 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

| improve this answer | |
  • Is there any system that would automatically capture the start time do you know? – FrankieJLyons May 19 '19 at 23:36
  • unfortunately no. this would be only workaround – user0 May 19 '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.