I had a very basic question on the duration of survey completion and I was surprised that the solution suggested to me by Qualtrics took me back in the olden golden Excel days of 90s era. I have 25 surveys which are closed. All I want to know is the average length (duration in minutes) for each survey. As per Qualtrics, I need to go to each survey, add Duration column in data analysis tab, export data into excel, get the total duration for each respondent, get the mean/average time in seconds, and then convert it into minutes in excel. Pheeeeewwww! Seriously?
I just want to confirm if this is the only way to get the average length of the survey or if anybody has any better suggestions. Thank you