#1 2011-02-08 19:19:34

**_mikesmartinez_**

Interpreting Report Data from .CSV File

I'm trying to average the amount of time users took to take a test. I downloaded the report data wich puts it into a .csv file. The amount of time that users took to take the test is in the "time-taken" field but the format is not in a readable format. For example, one person took 02:04:39 to take the test but the .csv data shows this as 7478610. How can I convert this to a time format?

**_Purnima_**

Re: Interpreting Report Data from .CSV File

The value is on mSec. You can write a macro to convert this to Hr:MM:SS format in CSV.

**_mikesmartinez_**

Re: Interpreting Report Data from .CSV File

Thanks. I don't really know how to create a macro but knowing that the format of the time is given in milliseconds helped. Maybe there's an easier way but I did this instead and it also worked:
Made cell reference: =((cell/1000)/86400) → then formatted that into h:mm:ss format.

**_Purnima_**

Re: Interpreting Report Data from .CSV File

I am sure this is equally good.