Calculate survey time in excel

[Kal_Lam]

Could you please have a look at the post discussed previously (it should 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!