Download and Reformat Response Times in Milliseconds

 

Response times within the mobile application are recorded in milliseconds; however, most people do not need this level of precision.  If you aren’t most people, and are interested in measuring response times to the millisecond, follow these steps:

  • In the data download section, be sure to select “Yes” for the “Report Response Times in Milliseconds”. 

  • Download the data and open it in Excel. 
  • In Excel, you will see that the times are not reported to the millisecond.  That has to do with the way Excel reads CSV files.  To fix this, do the following: 
  • Highlight the cells where you want time to be reported in milliseconds. 
  • Choose “Format Cells” from the menu. 
  • Select Custom (see below) 
  • Enter the following in the “Type” field (hh:mm:ss.000”) 
  • Click “Ok”. 

  • You will see that values reported in the “Time” column of the Excel file appear to incorrectly report the time when a response was given.  They too need to be reformatted. You can change the format by following the same steps as before, but this time select “Time” instead of “Custom” and then choose the time format that best fits your needs. 
Have more questions? Submit a request

Comments