loading Loading...
add chat to your website

How to Download Quiz Report in a Different Time Format for Additional Stats

 

When you download reports, to make them more readable we report time taken by a user to completate the quiz in a readable format such as "10 min 30 sec". If you need to transalate this into just seconds for doing certain analysis, here is the Excel formula that will translate the “nn hrs nn min nn sec” into a numeric field with the number of seconds.

 

LOOKUP(9.9E+307,86400*RIGHT("00:00:"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F3," ",""),"hrs",":"),"min",":"),"sec",""),ROW(INDIRECT("1:"&LEN(F3)))))

 

Simply download the data we provide to excel and use the above formula to translate time taken to seconds. You would just need to change the two references to F3 to the correct Excel column.

 

A sample excel sheet contributed by our user John R. is attached.

 

Attachment (s)

 

 

Related Articles:

What Are Advanced Progress Reports?
How to View Time Taken per Quiz and per Question
How to Share Quizzes With Learners