Duration of an investigation

[moisebyamungu]

Bonjour cher(e)s amis

J’ai une préoccupation.
J’aurais voulu que vous m’aidiez avec la formule excel pour calculer la durée d’une enquête réalisée avec l’outil kobocollect, une fois les données exportées sous excel.

Merci

[Kal_Lam]

@moisebyamungu, we have a bunch of workarounds discussed previously (it should help you meet your needs):

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)

Another one …

How to calculate per page data entry duration (in ENKETO, pages theme)?

Hi @kabira_namit, Welcome back to the community! If that is what you require, you could do it as outlined in the image shown below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Time difference to fill-up a section.xlsx (9.9 KB) Have a great day!

One more …

Calculate survey time from Metadata

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

This could also be helpful …

How to record time in each section of questionnaire

Maybe the workaround shared below should solve your issue: In the survey tab of your xlsform: [Image 1] In the settings tab of your xlsform: [Image 2] Reference xlsform: Time Difference.xls (32 KB) Note: Using this approach, the enumerator need not enter the time. It get’s automatically entered by the system. The once used just below the time should allow you (as an admin) to keep a record if the enumerator has changed the time manually while collecting data. This is not seen/observed by th…