topic Calculate total time from start and end time fields in ArcGIS Survey123 Questions

Calculate total time from start and end time fields

GISManager4 — Fri, 13 Dec 2019 17:57:53 GMT

I have researched the blog posts on here, but have not found the calculation for Survey123 Connect v3.7.60. Users are filling out a start and end time, using time field types. I want to calculate the total hours from those fields.

Re: Calculate total time from start and end time fields

Jim-Moore — Mon, 16 Dec 2019 03:00:29 GMT

For two time questions, you could use something like:

int(${endtime} - ${starttime}) div (1000 * 60)

Note that this returns elapsed minutes. For more information please see this handy blog and documentation:

https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis

Decimal date time—Survey123 for ArcGIS | Documentation

Best regards,

Jim

Re: Calculate total time from start and end time fields

GISManager4 — Tue, 17 Dec 2019 20:37:53 GMT

I have read both articles, but does not clearly explain how to accomplish the goal.

Re: Calculate total time from start and end time fields

DougBrowning — Wed, 18 Dec 2019 17:51:25 GMT

Try this post

https://community.esri.com/thread/244018-calculating-minutes