Calculate survey time from Metadata

how I can calculate the time between start and end (in exported data excel)

Hi @rahhal,

Would you mind having a look at the post that has been discussed previously. It should solve you issue:

Have a great day!

1 Like

Thanks Kal Lam
but i need to use time from kobo metadata question

1 Like

Hi @rahhal,

If this is your requirement, you could do it as shown in the image below:

In the survey tab of your xlsform:

Data recorded in the KoBoToolbox server:

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!

2 Likes