Calculate total time from start and end time fields

884
3
12-13-2019 09:57 AM
GISManager4
Occasional Contributor

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.

Tags (1)
0 Kudos
3 Replies
Jim-Moore
Esri Regular Contributor

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

GISManager4
Occasional Contributor

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

0 Kudos
DougBrowning
MVP Esteemed Contributor
0 Kudos