Calculate length of interview with start/end timestamps

[Kal_Lam]

Regarding your first query:

@sdalle

1. Is there a way that I can I use this timestamp format to calculate the length of the interview in Excel?

Maybe this post discussed previously should help you solve your first query:

Calculate survey time in excel

Hi @rahhal Thank you for your query. I would like to start this with a disclaimer that this is an excel function more than it is a KoBoToolBox function. The best approach would be to always include this in a calculate question (which is hidden from the respondents) and you can then have it exported within your data. However considering that most of our users may want to go the long route of calculating this in excel, I have prepared the following workaround in excel that uses a number of calcu…

Regarding your second query:

@sdalle

2. For future surveys, would it work if I insert a calculate question with the following formula: ${end}-${start}

Maybe this post discussed previously should help you calculate your survey time:

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!

and this post too …

Input time to calculate the survey duration

Hi @tulus45, You could also give a try to capture the survey time as shown in the image below: [Image%201] Reference xlsform: Time Difference.xls (33 KB)