topic Subtracting time in Survey123 in ArcGIS Survey123 Questions

Subtracting time in Survey123

MaryWasson — Wed, 17 Feb 2016 20:45:42 GMT

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

Re: Subtracting time in Survey123

IsmaelChivite — Thu, 18 Feb 2016 12:31:41 GMT

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

Re: Subtracting time in Survey123

MaryWasson — Thu, 18 Feb 2016 14:55:12 GMT

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