Subtracting time in Survey123

[MaryWasson]

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

[IsmaelChivite]

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​

[MaryWasson]

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