Falsified time calculation of audit files (metadata)

Dear Community,

Please review the attached image. We have identified an issue with the time calculation for each question in the audit file. This problem leads to unrealistic time allocations for questions, as equal amounts of time are assigned to multiple questions, resulting in extended interview durations, especially with longer time periods.

I would greatly appreciate it if you could offer a solution.

@Sulaiman_Anwary, maybe you will also need to share with the community how you calculated time. That should give the community a clue of what went wrong.

Oh, sorry for the confusion
here is the calculation method for each question

audit.csv (23.7 KB)
please find the attached for the audit file

thank you