- Topics: Active | Unanswered
Pages: 1
Topic closed
#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?
Offline
#2 2011-02-09 02:30:41
- **_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.
Offline
#3 2011-02-09 12:13:34
- **_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.
Offline
#4 2011-02-10 01:13:27
- **_Purnima_**
Re: Interpreting Report Data from .CSV File
I am sure this is equally good.
Offline
Pages: 1
Topic closed