Calculate total time from start and end time fields

Question

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.

dougbrowning · Answer

Try this post

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

GISManager4 · Answer

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

Jim Moore · Answer

Hi

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