Announcing the new Datavyu v1.3.6 with enhanced features and transcription support!

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 26 May '14, 10:49

phie's gravatar image

phie
16223
accept rate: 0%


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?

permanent link

answered 03 Jun '14, 18:28

david's gravatar image

david ♦
143235
accept rate: 4%

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.

permanent link

answered 04 Jun '14, 12:57

david's gravatar image

david ♦
143235
accept rate: 4%

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!

permanent link

answered 23 Jun '14, 04:56

phie's gravatar image

phie
16223
accept rate: 0%

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".

permanent link

answered 23 Jun '14, 18:25

david's gravatar image

david ♦
143235
accept rate: 4%

Works! Thank you!

permanent link

answered 24 Jun '14, 04:27

phie's gravatar image

phie
16223
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×24

question asked: 26 May '14, 10:49

question was seen: 7,217 times

last updated: 24 Jun '14, 04:27

powered by OSQA