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?
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
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
Retrieving data ...