How can I track the time it takes for someone to fill out a Google form?

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.

26.9k 10 10 gold badges 53 53 silver badges 78 78 bronze badges asked May 17, 2019 at 22:40 FrankieJLyons FrankieJLyons 43 1 1 silver badge 4 4 bronze badges

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

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

answered May 17, 2019 at 22:56 26.9k 10 10 gold badges 53 53 silver badges 78 78 bronze badges 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 Commented May 19, 2019 at 23:44

Related

Hot Network Questions

Subscribe to RSS

Question feed

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

Site design / logo © 2024 Stack Exchange Inc; user contributions licensed under CC BY-SA . rev 2024.9.4.14806