Import external Data > Format external data

INTERACT stores all time information as 100 NanoSecond values, but if you plan to copy external data, you can prepare your time information in those formats:

o100 NanoSecond values (1 sec = 10000000 Ns)

ohh:mm:ss:FRAMES

ohh:mm:ss.milliseconds

oYYYY-MM-DD hh:mm:ss:FRAMES

oYYYY-MM-DD hh:mm:ss.milliseconds

Calculate time values

In most cases, your time information is available in another format. Find some instructions on how you can transform this information with the help of MS Excel. We presume that you know the basics of building formulas in Excel.

Milliseconds to 100 Nanoseconds

If your external data contains milliseconds, you simply need to multiply your time value with 10000

•In Excel, use a formula like this: =A2*10000

Minutes, Seconds to 100 Nanoseconds

If your time information is listed in minutes,seconds, you need to multiply your values with 10000000 and remove any further decimals.

•In Excel, use a formula like this: =ROUND(A2*10000000;0)

Day time values

If your data offers only day time values, you need to 'convert' those values into one of the accepted formats.

Day time values to 100 Nanoseconds

Excel does not offer a command to convert day time values to seconds, but because a day has 86400 seconds (24*60*60), you can multiply your day time value like this:

o=[A2]*86400*10000000

Day Time Values to INTERACT time value

It is also possible to format time information like this:

•To get HH:MM:SS:FRAMES, use a formula like this: =TEXT(A2;"hh:mm:ss")&":00"

•To get HH:MM:SS.ms, use a formula like this: =TEXT(A2;"hh:mm:ss")&".000"

•To get YYYY-MM-DD hh:mm:ss:FRAMES and your date is stored in a separate column, use a formula like this: =TEXT(A2;"YYYY-MM-DD")&" " &TEXT(B2;"hh:mm:ss")&":00"

•To get YYYY-MM-DD hh:mm:ss.ms and your date is stored in a separate column, use a formula like this: =TEXT(A2;"YYYY-MM-DD")&" " &TEXT(B2;"hh:mm:ss")&".000"

Note: The exact final formula depends on the format of your time information and the cell position of your values.

Frames to 100 Nanoseconds

If your time information is available in video frames, the required formula depends on the number of frames per second of the corresponding video:

o25 fps: frame count * 400000

o30 fps: frame count * 333333

o29.97 fps: frame count * 333667

oxx fps: frame count * (1000/fps*10000)

Accepted Time Formats

Accepted Time Formats