1 Topic by berkbulus

  • berkbulus
  • Member
  • Offline

Whenever I export my key images whether it's Excel or LibreOffice Calc, it's exporting the times as Milliseconds.

Example:
8.772
9.489
9.839
10.172
17.009
23.913
30.867
38.088
41.623

But I only want until hundredth of a second. Such as:
8.77
9.49
9.84

Is this somehow achievable in the settings?

2 Reply by merlemitchell6779 (edited by merlemitchell6779 2024-03-13 07:53:52)

  • merlemitchell6779
  • -
  • Offline
berkbulus wrote:

Whenever I export my key images whether it's Excel or LibreOffice Calc, it's exporting the times as Milliseconds. tunnel rush

Example:
8.772
9.489
9.839
10.172
17.009
23.913
30.867
38.088
41.623

But I only want until hundredth of a second. Such as:
8.77
9.49
9.84

Is this somehow achievable in the settings?

A simple method to convert the milliseconds to seconds with two decimal places:

1. Export your key images and their timestamps in milliseconds as you normally would.

2. Open the exported CSV file in Excel or LibreOffice Calc.

3. In a new column next to your milliseconds data, use the following formula to convert milliseconds to seconds (assuming your first millisecond value is in cell A2):

=A2/1000


1. Drag the formula down to apply it to all your data.

2. Format the new column to display numbers with two decimal places:
In Excel: Right-click the cells, select 'Format Cells', choose 'Number', and set the decimal places to 2.

In LibreOffice Calc: Right-click the cells, select 'Format Cells', go to the 'Numbers' tab, choose 'Number', and set the decimal places to 2.

3 Reply by sangary2130

  • sangary2130
  • -
  • Offline

hi,
can i know how to get trained in using Kinovea ? anyone to assist me ?