How do you subtract time in the xls form in Survey123? Does anyone have suggestions on how to track how long it takes someone to complete a form or a task?
Thank you,
Mary
Hi Mary,
try using the start and end question types. These type of questions will capture the exact time at which a Form is opened and flagged as done. For more details have a look at the where, when, who is capturing data? blog post.
In the past, I have used these fields and then downloaded the survey results as a file geodatabase so I could add a new field in the table and calculate with the time difference. A handful of manual steps, but gets the job done.
The syntax to use in the field calculator is something like this: DateDiff("m", [received], [finished])
Check this for details: ArcGIS Help 10.1
Ismael
Mary Wasson
After I posted the question I did read more about the start and end metadata. I think that will be useful along with the field calculator once it is exported.
Thanks for your help! Mary
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
