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.
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
I have read both articles, but does not clearly explain how to accomplish the goal.