Hello! I have a big issue exporting data into csv (and following import to excel). The time codes are not right at all. In datavyu the last code ends with 8 mins, in csv/excel the same last time code's time is 5 mins, for example. It seems like it is not recognizing minutes but continues counting after 60 seconds to 61 etc. instead of switching to 1min1sec. Is there a solution?
asked
phie |

Thank you for letting us know about this issue. We've notified the developers and they're working on a fix for the next version. Just to make sure, are you using the export feature or is this issue arising from a script that you've written?
answered
david ♦ |

The issue is that when exporting into Excel it puts the time in raw milleseconds rather than min:sec:ms. A quick way to change it from milleseconds into the more easily understood min:sec:ms is to use an Excel formula. In excel, highlight the cell with a time, then enter the formula (cell)/60/60/1000/24 in the formula builder and click enter. Drag the newly formatted cell down for an entire column so all of the cells get the new formula. Then go to Format/Cells/Custom and enter in "Type: mm:ss.000 and then "ok". After that, your times in your exported file and the times in your spreadsheet should be exactly the same.
answered
david ♦ |

Thank you, David, that sounds absolutely right! Just, how do I enter the formular? I highlight the cell with a time, so its a number e.g. 77777 in cell c2, then I enter "=77777/60/60/1000/24"? Or do I enter "=c2/60/60/1000/24" (then the number 77777 would be gone and there is an error that I can't have formulars in one cell including this cell) ? Thanks!
answered
phie |

Your first formula will work, but it will be time consuming for you to type that all in manually. I left out a key step in my above answer. You need to insert a column next to the column that you are trying to manipulate. Then you can type in the formula =c2/60/60/1000/24 in the cell adjacent to c2 (e.g. if the new column is directly to the right you would be entering the formula into d2). Then drag the newly formatted cell down for an entire column so all of the cells get the new formula. Then go to Format/Cells/Custom and enter in "Type: mm:ss.000 and then "OK".
answered
david ♦ |