4

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.

1
  • 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. Commented May 17, 2019 at 23:55

1 Answer 1

3

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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