Survey duration

[xaldoon2023]

How to Calculate Survey duration manually in excel

[wroos]

Which variables do you plan to use? Be aware that the end datetime (metadata) will change on every save, incl. later (modal) edit on server level. (Different to submission_time and start)

You may also have a look here: Form Logic - ODK Docs. And the search function of this forum can show you previous discussions and examples, e.g. Search results for 'calculate time of survey' - KoboToolbox Community Forum.

[Kal_Lam]

Welcome to the community, @xaldoon2023! As outlined by @wroos, this post discussed previously should help you solve your issue:

Calculate survey time from Metadata

Hi @rahhal, If this is your requirement, you could do it as shown in the image below: In the survey tab of your xlsform: [Image 1] Data recorded in the KoBoToolbox server: [Image 2] Reference xlsform: Start & End Time (Metadata).xlsx (9.7 KB) N.B. Please note that the time difference calculated in this approach cannot be displayed in the form as you are not able to capture the end time. End time are captured once you press the Save button or the Submit button. Have a great day!